Microsoft Office Tutorials and References
In Depth Information
Adjusting the Series Plot Order
Figure 3-10: The series names have been changed; the new
names are shown in the legend.
When you remove the first argument in a SERIES formula, make sure that
you do not delete the comma that follows the first argument. The comma is
required as a placeholder to indicate the missing argument.
To create a series with no name, use a set of empty quotation marks for the first
argument in the SERIES formula.
Adjusting the Series Plot Order
Every chart series has a plot order parameter. When you access the Series tab in the
Source Data dialog box, the Series list box displays the chart series in the order in
which they are plotted. In addition, a chart’s legend displays the series names in the
order in which they are plotted.
To change the plot order, access the Format Data Series dialog box for any series
in the chart and then select the Series order tab. Select a series in the list box; then
use the Move Up and Move Down buttons to adjust its position.
Alternatively, you can edit the SERIES formulas — specifically, the fourth
parameter in the SERIES formulas. See the “SERIES Formula Syntax” sidebar 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 3-11 shows a
stacked-column chart generated from the data in A1:E1. 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.
After changing the plot order for the other SERIES formula, the chart now
appears as in Figure 3-12.
Figure 3-13 shows another example. This area chart displays three data series in
a 3-D Column Chart. The columns for the Laptops and PDA series are obscured by
Search JabSto ::




Custom Search