Change data markers in a line, scatter, or radar chart

If you have a line, (xy) scatter, or radar chart, you can change the look of the data markers (data marker: A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell. Related data markers in a chart constitute a data series.) to make them easier to distinguish.

Formatted combination chart

The line in this combination chart shows round data markers instead of the usual square data markers.

For more information about how to create these types of charts, see Present your data in a scatter chart or a line chart and Present your data in a radar chart.

  1. In a line, scatter, or radar chart, do one of the following:
    • To select all data markers in a data series, click one of the data markers.
    • To select a single data marker, click that data marker two times.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  1. On the Format tab, in the Current Selection group, click Format Selection.

Excel Ribbon Image

  1. Click Marker Options, and then under Marker Type, make sure that Built-in is selected.
  2. In the Type box, select the marker type that you want to use.

 Note   If you select a picture marker, you must also complete step 6 to select the picture that you want to use.

  1. In the Size box, select the size that you want to use for the markers.

 Note   This option is not available for picture markers. Make sure that the picture you want use is sized appropriately for your chart.

  1. To change the look of the markers, click Marker Fill, and then select the options that you want.

 Tip   To fill a data marker with a picture, click Picture or texture fill, and then under Insert from, click File, Clipboard (if you copied a picture there), or Clip Art to select the picture that you want to use.

 Note   You cannot change the default settings for marker options. However, you can save your chart as a template that you can apply when you create another chart. For more information, see Reuse a favorite chart by using a chart template.

 
 
Applies to:
Excel 2007, Outlook 2007, PowerPoint 2007, Word 2007