Microsoft Office Tutorials and References
In Depth Information
Plotting noncontiguous source ranges
Figure 19-8 With the Filter button you can easily remove a particular series from a chart or
simply highlight a series temporarily.
Plotting noncontiguous source ranges
There might be times when the data you want to plot does not lie in a contiguous block
of cells. Suppose, for example, that from the following table you want to generate a
column chart that compares Petra Chvojkova with Andrej Koklic, omitting the other five
salespersons:
The simplest way to do this is to use the filter control next to the Salesperson heading to
restrict the table to Chvojkova and Koklic. Excel responds by hiding rows 2, 4, 5, 7, and 8,
and any chart generated from the table will plot only the visible rows. If you don’t have
filter controls, you can accomplish the same feat by manually hiding the rows you want to
omit using the Format command in the Cells group of the Home tab.
Search JabSto ::




Custom Search