How to: Specify a Chart Area for a Series

The chart is the top-level container that includes the outer border, the chart title, and the legend. By default, the chart contains one default chart area. The chart area is not visible on the chart surface, but you can think of the chart area as a container that encompasses only the axis labels, the axis title and the plotting area of one or more series. The following illustration shows the concept of chart areas within a single chart.

Shows a diagram of a chart area

By default, all series are added to the default chart area. When using area, column, line, and scatter charts, any combination of these series can be displayed on the same chart area. If you have several series in the same chart area, the readability of the chart is reduced. You may want to separate the chart types into multiple chart areas. Using multiple chart areas will increase readability for easier comparisons. For example, price-volume stock charts often have different ranges of values, but comparisons can be made between the price and volume data over the same period of time.

The bar, polar, or shape series can only be combined with series of the same chart types in the same chart area. If you are using a Polar or Shape chart, consider using a separate chart data region for each field that you wish to show.

To associate a series with a new chart area

  1. Right-click anywhere on the chart and select Add New Chart Area. A new, blank chart area appears on the chart.

  2. Right-click the series on the chart or right-click a series or data field in the appropriate drop-zones and open the Series Properties dialog box.

  3. In Axes and Chart Areas, select the chart area that you want the series to be shown in.

  4. (Optional) Align the chart areas vertically. To do this, right-click the chart and select Chart Area Properties. In Alignment, select another chart area that you want to align the selected chart area with.

Community Additions