Microsoft Office Tutorials and References
In Depth Information
Other Series Enhancements
The data for the additional ranges used in the second chart are in columns C and
D. The formula in C2, which was copied to the cells below, is
=AVERAGE($B$2:$B$13)-STDEV($B$2:$B$13)
The formula in D2, also copied to the cells below, is
=AVERAGE($B$2:$B$13)+STDEV($B$2:$B$13)
One advantage to these additional series is that you have more control over the
formatting. Y Error bars, for example, always appear as vertical lines and cannot be
connected horizontally. In addition, using a series for error bars enables you to
display a description in the legend. Most would agree that the bottom chart is less
cluttered and more legible.
Other Series Enhancements
So far, this chapter has covered trendlines and error bars. These are, essentially, two
ways to augment a chart data series. In addition, some chart series can be enhanced
with:
Drop lines
High-low lines
Up/down bars
Varied colors
These features are discussed in the sections that follow.
Series lines
A series line is applicable only for the 2-D variants of stacked-bar charts and
stacked-column charts. Figure 5-27 shows an example of a stacked-column chart
with the series line option enabled. As you can see, the series lines simply connect
the top of each data point with the next data point in the series.
To turn series lines on or off, access the Format Data Series dialog box for any
series in the chart. Click the Options tab and adjust the Series lines check box.
For a single-series bar chart or column chart, the Series lines check box is
disabled. If you would like to display a series line on such a chart, you need to
change the chart type to a stacked-column chart.
Search JabSto ::




Custom Search