Microsoft Office Tutorials and References
In Depth Information
Changing the Order of Your Data Series
Practical Charting
3. NowchooseInsert Charts,andthenpicktheappropriatecharttype.
Excel creates the chart as usual, but uses only the data you selected in steps 1 and
2, leaving out all other columns.
This approach works most of the time. However, if you have trouble, or if the
columns you want to select are spaced really far apart, then you can explicitly configure
the range of cells for any chart. To do so, follow these steps:
1. Create a chart normally, by selecting part of the data, and then, from the
Insert Chartsectionoftheribbon,choosingacharttype.
2. Selectthechart,andthenchooseChartTools|Design Data SelectData.
The Select Data Source dialog box appears (Figure 19-14).
Figure 19-14:
This dialog box shows a handy
secret about Excel charting. Excel
not only records the whole range
of cells that contain the chart
data (as shown in the “Chart
data range” text box), it also lets
you see how it breaks that data
up into a category axis and one
or more series (as shown in the
Legend Entries (Series) list).
3. Remove any data series you don’t want and add any new data series you
To remove a series, select it in the Legend Entries (Series) list, and then
click Remove.
To add a new series, click Add, and then specify the appropriate cell references for
the series name and the series values.
You can also click Switch Row/Column to change the data Excel uses as the category
axis (page 508) and you can adjust some more advanced settings, like the way Excel
deals with blank values, and the order in which it plots series (as explained in the
following sections).
Changing the Order of Your Data Series
If your table has more than one series, Excel charts it in the order it appears on your
worksheet (from left to right if your series are arranged in columns, or from top to
bottom if they’re arranged in rows). In a basic line chart, it doesn’t matter which
Search JabSto ::

Custom Search