Microsoft Office Tutorials and References
In Depth Information
Adjusting the Series Plot Order
Adjusting the Series Plot Order
Every chart series has a plot order parameter. A chart’s legend usually displays the series’ names in
the order in which they’re plotted. I say usually, because you do find exceptions. For example,
consider a combination chart that displays a column series and a line series. Changing the series order
doesn’t change the order in which the series are listed in the legend.
To change the plot order of a chart’s data series, use the Select Data Source dialog box. In the
lowerleft list, the series are listed in the order in which they’re plotted. Select a series and then use the
up- or down-arrow buttons to adjust its position in the list — which also changes the plot order of
the series.
Alternatively, you can edit the SERIES formulas — specifically, the fourth parameter in the SERIES
formulas. See the “SERIES formula syntax” sidebar, earlier in this chapter, for more information about
SERIES formulas.
For some charts, the plot order is not important. For others, however, you may want to change the
order in which the series are plotted. Figure 6-10 shows a stacked column chart generated from the
data in A2:E6. Notice that the columns are stacked, beginning with the first data series (Region 1) on
the bottom. You may prefer to stack the columns in the order in which the data appears. To do so,
you need to change the plot order.
Figure 6-10: The plot order of this chart doesn’t correspond to the order of the data.
After changing the plot order of the series, the chart now appears as in Figure 6-11.
Search JabSto ::




Custom Search