Microsoft Office Tutorials and References
In Depth Information
Chapter 13: Charts and Data Analysis
completely different story using the same data. (See “Choosing the Right Chart Type” on
page 429 for more details.) Start by selecting the data to be charted (including column and
row labels if you want them to be used as chart labels). The available chart types are listed
in the Charts group on the Insert tab, as shown here.
Clicking a specific chart type reveals a menu of subtypes for that category, arranged in
subcategories as shown here. To continue, you must select one of the available options. (Don’t
worry: if you change your mind, you can switch to a different chart type and subtype at any
Excel builds and displays the chart immediately, using source data you selected earlier (or
the current region, if you didn’t make a selection first). If the data isn’t appropriate for the
chart type you select, you might see an error message, which you must resolve before you
can continue. If your original data selection doesn’t result in the chart you were expecting,
you can modify the data selection or change the chart design as needed.
For details on how to change the source data for a chart, see “Linking Worksheet Data to
Chart Elements” on page 439.