Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 4 Describing Your Data 145

3 Click the Change Chart Type button on the Type group on the

Design tab.

4 Excel opens the Change Chart Type dialog box. From within the

dialog box click the Column chart type and then click the fi rst sub-

type, Clustered Column, in the dialog box (see Figure 4-11).

Figure 4-11
Changing the
chart type

stacked chart type 3-D chart sub-types

5 Click the OK button. As shown in Figure 4-12, Excel changes the

chart type, displaying the histogram bars side by side rather than

stacked.