Microsoft Office Tutorials and References
In Depth Information
Adjusting the Series Plot Order
the columns for the Desktops series. One solution is to edit the plot order parameter
of the SERIES formulas, as described previously. But in this case, there’s a more
1. Double-click the series axis (the “depth” axis, which contains the series
names) to display the Format Axis dialog box.
2. Select the Scale tab in the Format Axis dialog box.
3. Place a checkmark next to Series in reverse order.
4. Click OK.
Figure 3-11: The plot order of this chart does not correspond
to the order of the data.
Figure 3-12: After changing the plot order,
the stacked columns correspond to the order
of the data.
The result, shown in Figure 3-14, is a much more legible chart. Note that the
option to plot the series in reverse order does not actually change the plot order for
the SERIES formula. The SERIES formulas remain the same, but Excel displays them