Microsoft Office Tutorials and References
In Depth Information
Non-Contiguous Chart Ranges
Practical Charting
Non-Contiguous Chart Ranges
So far, all the chart examples have assumed the data you want to chart is placed in a
single, tightly packed table. But what if your information is actually scattered across
your worksheet? This scenario may seem unlikely, but it actually happens quite often
when you need to chart only part of the data in a table. Say you want to create a chart
using two or three columns, and these columns aren’t next to each other. In this case,
you need to take a few extra steps when you create your chart.
Imagine you have a table that records the monthly sales of 10 different regional offices.
However, you want to create a chart that compares only two of these offices. Your chart
will use the category information in column A (which contains the month in which
the sales were recorded), along with the values in column C and column D (which
contain the total amount of sales for the two regions in which you’re interested).
The easiest way to create this chart is to start by selecting the noncontiguous range
that contains your data. Here’s what you need to do:
1. First,usethemousetoselectthedataincolumnA.
Excel surrounds the data with a marquee. Don’t click anywhere else yet.
2. Then,holddowntheCtrlkeywhileyoudragtoselectthedataincolumnsC
andD.
Because you’re holding down the Ctrl key, column A remains selected (see
Figure 19-13).
Figure 19-13:
This worksheet shows a noncontiguous selection that
ignores the numbers from region 1. When you create the
chart, Excel includes only two series in the chart: one for
region 2, and one for region 3.
Search JabSto ::




Custom Search