Change the Chart Type

1. Click the chart to select it, whether it appears on its own sheet or on a data worksheet. A Chart Tools tab with three subtabs appears.
   
   
   
   
   
   
2. Choose Chart Tools Design => Type => Change Chart Type. The Change Chart type dialog box appears.
3. Select the different chart type and subtype you want.
   
   
   
   
   
   
4. Click OK. Excel modifies the existing chart.