Microsoft Office Tutorials and References
In Depth Information
SPECIFYING THE CATEGORY DATA AND SERIES DATA
of the Chart Wizard displays a small preview of your chart so that you can
immediately see the effect of changing the chart’s orientation.
For this example, Excel guessed correctly: The data is arranged in columns.
SPECIFYING THE CATEGORY DATA AND SERIES DATA
Look carefully at the preview and you’ll see that the chart is not correct. Excel
(incorrectly) identified the years in Column A as a data series. In fact, the years are
categories names and should be treated as text, not plotted as numeric values.
Because the Chart Wizard did not identify the categories, a change is required. This
change is made using the Series tab in Step 2 of the Chart Wizard (see Figure 1-14).
Figure 1-14: The Series tab in Step 2 of the
Chart Wizard
The Series list box shows the names of all the data series for the chart. Select a
series in the list box, and the range address for its name and data are shown in the
fields to the right. In this example, the Years series has its Name in range A3 and its
Values in range A4:A9.
Because the series labeled Years is not really a series (it contains the category (X)
axis labels), you need to delete it from the Series list box. To do so, select it and
click Remove. After removing the incorrect series, the preview will update. Now the
chart is looking better — but the years are not displayed along the category (hori-
zontal) axis.
The field for the Category (X) axis labels is empty, so you need to specify the range
for the category labels. To do so, click in the field and select A4:A9. Now the preview
chart looks correct (see Figure 1-15). The years appear as categories on the horizontal
axis, and the chart displays the four data series.
Search JabSto ::




Custom Search