Microsoft Office Tutorials and References
In Depth Information
Using Series on Different Sheets
The first argument is omitted, so Excel uses the default series name. The second
argument specifies six cells in column A as the category labels. The third argument
specifies six corresponding cells in column B as the data values. Note that the range
arguments for the noncontiguous ranges are displayed in parentheses, and each
subrange is separated by a comma.
Figure 3-15: This chart uses data in a noncontiguous range.
Using Series on Different Sheets
Typically, data to be used in a chart resides on a single sheet. Excel, however, does
allow a chart to use series from any number of worksheets, and the worksheets
need not even be in the same workbook.
Although a chart series can refer to data in other worksheets, the data for
each series must reside on a single sheet.
Normally, you select all the data for a chart and then use the Chart Wizard to
create the chart. But if your chart uses data on different worksheets, you need to
use several steps because the Chart Wizard cannot be activated when a multisheet
selection is made. You need to create the chart using data from a single sheet and
then add new series after the chart is made (see “Adding a New Series to a Chart,”
earlier in the chapter). Alternatively, you can select ranges from another worksheet
in Step 2 of the Chart Wizard dialog box (Series tab).
Figure 3-16 shows a chart that uses data from two other worksheets.
Search JabSto ::




Custom Search