Selecting and Customizing a Chart Type

When you create a new chart, Excel lets you select from 73 chart types in 14 categories (although a significant number of these choices are actually just minor variations of others in the same category). You can also choose from a gallery of 20 built-in custom chart types, and you can create and save your own chart types as well. The type of data you're planning to plot usually dictates which type of chart you should choose.

Choosing a Standard Chart Type

When you start the Chart Wizard, the first step is to specify what type of chart you want to create. After you create a chart, you can easily change it to a new type; right-click the chart area or plot area and select Chart Type, or click the Chart Type ...

Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.