Microsoft Office Tutorials and References
In Depth Information
Chart Wizard – Step 1 of 4
For this example, select the range A3:E9. This range includes the category labels
but not the title (which is in A1).
Figure 1-11: Data to be charted
The data that you use in a chart doesn’t have to be contiguous.You can press
Ctrl and make a multiple selection. The initial data, however, must be on a
single worksheet. If you need to plot data that exists on more than one
worksheet, you can add more series after the chart is created (or use the
Series tab in Step 2 of the Chart Wizard). In all cases, however, data for a
single chart series must reside on one sheet. In other words, the data for a chart
series cannot extend across multiple worksheets. This issue is addressed in
After you select the data, start the Chart Wizard, either by clicking the Chart
Wizard button on the Standard toolbar or by selecting Insert
Chart. Excel displays
the first of four Chart Wizard dialog boxes.
While using the Chart Wizard, you can go back to the preceding step by clicking
the Back button. Or, you can click Finish to close the Chart Wizard. If you close the
Chart Wizard early, Excel creates the chart using the information that you provided
up to that point.
Don’t be too concerned about creating the perfect chart. You can always change,
at any time, any choice that you make in the Chart Wizard.
Chart Wizard — Step 1 of 4
Figure 1-12 shows the first Chart Wizard dialog box, in which you select the
chart type. This dialog box has two tabs: Standard Types and Custom Types. The
Standard Types tab displays the 14 basic chart types and the subtypes for each.
The Custom Types tab displays some customized charts (including user-defined