Microsoft Office Tutorials and References
In Depth Information
Refer to Chapters 4 and 5 for additional information about the elements
available for various chart types.
This section discusses the various methods available to create a chart. For
maximum flexibility, you’ll probably want to use the Chart Wizard for creating most of
Creating a chart with one keystroke
For a quick demonstration of how easily you can create a chart, follow these
instructions. This example creates a chart on a separate Chart sheet.
1. Enter data to be charted into a worksheet. Figure 1-8 shows an example
of data that’s appropriate for a chart.
2. Select the range of data that you entered in Step 1, including the row and
column titles. For example, if you entered the data shown in Figure 1-8,
3. Press F11. Excel inserts a new chart sheet (named Chart1) and displays the
chart, based on the selected data. Figure 1-9 shows the result.
Figure 1-8: This data would make a good chart.
In this simple example, Excel created its default chart type (which is a
twodimensional column chart), using the default settings. This chart, like all charts, can
be further customized in many ways. For example, you would probably want to add
a title to the chart, and you may prefer to change the colors used in the columns.
Creating a chart with a mouse click
To create an embedded chart with a single mouse click: