Chapter 21: Using Advanced Charting Techniques
21
FIGURE 21.19
This chart uses three columns of text for the category axis labels.
Working with Data Series
Every chart consists of one or more data series. This data translates into chart columns,
bars, lines, pie slices, and so on. This section discusses some common operations that
involve a chart’s data series.
When you select a data series in a chart, Excel does the following:
■ (^) Displays the series name in the Chart Elements control (located in the Chart Tools
➪ Format ➪ Current Selection group
■ (^) Displays the Series formula in the Formula bar
■ (^) Highlights the cells used for the selected series by outlining them in color