Show All

Select a different chart type

For most 2-D charts, you can change the chart type of either a data series or the entire chart. For bubble charts, you can change only the type of the entire chart. For most 3-D charts, changing the chart type affects the entire chart. For 3-D bar and column charts, you can change a data series to the cone, cylinder, or pyramid chart type.

1. To change the chart type, do one of the following:
   • For the entire chart, click the chart.
   • For a data series, click the data series.
2. On the Chart menu, click Chart Type.
3. On the Standard Types tab, click the chart type you want.

   If you are changing the chart type for one data series and not the entire chart, be sure the Apply to selection check box is selected.

   To apply the cone, cylinder, or pyramid chart type to a 3-D bar or column data series, click Cylinder, Cone, or Pyramid in the Chart type box on the Standard Types tab, and then select the Apply to selection check box.