Part III: Creating Charts and Graphics
412
Trying other chart types
Although a clustered column chart seems to work well for this data, there’s no harm in checking
out some other chart types. Choose Design ➪ Type ➪ Change Chart Type to experiment with
other chart types. This command displays the Change Chart Type dialog box, shown in Figure
18.8. The main categories are listed on the left, and the subtypes are shown as icons. Select an icon
and click OK, and Excel displays the chart using the new chart type. If you don’t like the result,
select Undo.Tip
You can also change the chart type by selecting the chart and using the controls in the Insert ➪ Charts group. n
FIGURE 18.8Use this dialog box to change the chart type.
Trying other chart styles
If you’d like to try some of the prebuilt chart styles, select the chart and choose Chart Tools ➪
Design ➪ Chart Styles gallery. You’ll find an amazing selection of different colors and effects, all
available with a single mouse click.Tip
The styles displayed in the gallery depend on the workbook’s theme. When you choose Page Layout ➪
Themes ➪ Themes to apply a different theme, you’ll have a new selection of chart styles designed for the
selected theme. n