Change the look of data series

A data series (data set) is a set of related values in a chart—for example, all the bars of the same color in a bar chart, or a single line in a line chart.

You can emphasize trends in your chart by changing the appearance, position, or spacing of one or more of the data series.

Change the look of chart data series

You can change the look of any data series in a chart to differentiate it from other series. For bar charts, for example, you can fill the bars in different series with a different color or a color gradient, apply a different outline (stroke) style, and more. For scatter charts, you can change the symbol that represents each point and add connection lines between the points.

Note: You can't change the look of a single data point in a series (a single bar in a bar chart, for example). All changes you make apply to every data point in the series.

  1. Click the chart, then click one element of a data series (for example, one bar or column, pie wedge, or scatter point).

    The entire data series is selected.

  2. In the Format  sidebar, click the Style tab.

  3. Use the controls in the sidebar to make changes; to see all options, you may need to click the disclosure triangle next to the name of each section.

    The changes affect only the selected data series. To change another series, click one of its elements, then make changes.

    To select multiple series, click a series element, then Command-click an element in another series. To select all series, click a series element, then press Command-A.

    Controls for changing the appearance of data series.

Tip: You can choose a coordinated set of colors for all the data series in the chart at once. Click the chart, click the Chart tab in the sidebar, then click the Chart colors button and select colors. To preview the colors in your chart, hold the pointer over a color combination.

Change the spacing of elements in bar or column charts

You can set the amount of space between the columns or bars in a column or bar chart.

  1. Click the chart, then in the Format  sidebar, click the Chart tab.

  2. Click the disclosure triangle next to Gaps, then click the arrows to set the desired amount of space.

    A column chart showing the gap between columns versus the gap between sets.

Change the position of pie chart wedges or donut chart segments

  1. Select the pie or donut chart.

  2. Do one of the following:

    • Move only selected wedges or segments: Double-click the wedge or segment, or Command-click multiple items, then drag.

    • Move all wedges in a pie chart: In the Format  sidebar, click the Wedges tab. Click the disclosure triangle next to Wedge Position, then drag the Distance from Center slider to separate the wedges.

      A pie chart with wedges separated.

You can also move the Rotation Angle control to change the orientation of pie wedges or donut segments. You may want to emphasize some data, for example, by positioning certain wedges at the top or bottom of the chart.

Change the depth of a 3D chart and the shape of series elements

You can change the chart depth, lighting style, bar shape, bevels, and rotation of 3D charts.

  1. Click the 3D chart to select it, then in the Format  sidebar, click the Chart tab.

  2. Click the disclosure triangle next to 3D Scene, then use the controls to make adjustments.

Bevel the edges between series or wedges in 3D stacked or pie charts

You can increase the distinction between series in 3D stacked bar or column charts and 3D pie charts by beveling the edges where the series meet.

A 3-D pie chart with and without beveled edges.
  1. Click the chart, then in the Format  sidebar, click the Chart tab.

  2. Click the disclosure triangle next to 3D Scene, then select the Show Bevels checkbox.

Resize the center hole of a donut chart

You can save a chart’s look as a new style.

If you can’t edit a chart, you may need to unlock it.

See alsoChange a chart from one type to anotherModify chart data referencesChange the look of chart text and labelsUse chart styles