Microsoft Office Tutorials and References
In Depth Information
Sketch of column and pie charts
Sales by Region and Model
Charts , also known as graphs, provide a visual representation of the workbook data.
Using charts, one can often see trends in the data that are more difficult to detect by view-
ing the raw numbers in a table. A chart can also be used to highlight items of interest,
such as a region with low sales or an unexpectedly good sales month. Excel makes it easy
to create charts through the use of the Chart Wizard , a series of dialog boxes that prompt
you for information about the chart you want to create. This includes information such as
the chart type, the cell range that the chart is based on, and features that the chart will
contain. You will use the Chart Wizard to create the first chart that Alicia sketched for
you—the column chart of the sales figures broken down by region and telescope model.
Creating a Chart Using the Chart Wizard
The Chart Wizard is a series of four dialog boxes, and each one is a step in the process of cre-
ating your chart. At each point in the process, you provide more detailed information about
the chart you want Excel to create. Figure 4-3 describes the four steps in the Chart Wizard.
Tasks performed in each step of the Chart Wizard
Select from list of available chart types and corresponding sub-types, or choose to
customize a chart type
Chart Source Data
Specify the cells that contain the data on which the chart will be based and the cells
that contain the labels that will appear in the chart
Change the appearance of the chart by selecting the options that affect titles, axes,
gridlines, legends, data labels, and data tables
Specify where the chart will be placed: embedded as an object in the worksheet
containing the data or on a separate worksheet, also called a chart sheet
You can stop the Chart Wizard at any time, and Excel will complete the remaining dia-
log boxes for you using the default specifications for the chart you have chosen.