Microsoft Office Tutorials and References
In Depth Information
Very Important Facts about All Excel Charts: Selecting a Series
example, all of the sales columns will be marked if you click on a single column of the
sales series.) If you click on the same column a second time, it marks the individual
Use the rule: First click marks all of the points (columns) in a series
click marks the individual point (or a single column). See Figure 6.11. Marking a
series this way (first click for all the points and second click for the individual point)
works in all charts in Excel.
The advantage of being able to mark individual columns rather than the entire
series is the possibility of formatting the individual column versus the entire series.
FIGURE 6.11 Select a Series or a Single Data Point