Changing Chart Types

Excel makes changing chart types of an existing chart a breeze. You can change chart types by following these steps:

1. Select the chart you want to change. You do this by clicking on the chart, if you are selecting an embedded chart. (Eight handles appear around the perimeter of the chart.) If you are selecting a chart sheet, simply make sure the sheet is displayed.
2. Choose the Chart Type option from the Chart menu. Excel displays the Chart Type dialog box. (Click here to see a related figure.) This dialog box looks very similar to one of the steps in the Chart Wizard. Notice that the current chart type is highlighted in the dialog box.
3. Select any of the major chart types shown in the Chart Type list. When you select a type, the information in the Chart Sub-type area of the dialog box is changed.
4. Click on one of the Chart Sub-types shown at the right side of the dialog box.
5. Click on the OK button. Your chart is reformatted using the chart type and sub-type you selected.