Microsoft Office Tutorials and References
In Depth Information
Chart Wizard – Step 3 of 4
Figure 1-15: The incorrect series has been
removed and the Category axis labels have
Excel uses the data type to identify category data. In this example, the years in
Column A are numeric values, so Excel treats them as data. Also, note that
when category data is not specified, Excel uses consecutive integers on the
Category axis: 1, 2, 3, and so on. In this example, you might think that
formatting the years as Text would cause Excel to treat them as categories — but it
doesn’t work. You can, however, precede each year value with an apostrophe.
In such a case, the years are interpreted as text and assigned as the
categories. Yet another option is to remove the column heading (Years) from cell
A3. After you do so, Excel will correctly identify the data as category labels.
Click the Next button to advance to the next dialog box.
Chart Wizard — Step 3 of 4
In the third Chart Wizard dialog box, shown in Figure 1-16, you specify most of the
options for the chart. This dialog box has six tabs:
Titles: Add titles to the chart. Note that these fields are not range selector
fields. You must enter text, not a cell address.
Axes: Turn on or off axes display and specify the type of axes.