Select a different chart type

For most 2-D charts, you can change the chart type of the entire chart to give the chart a completely different look, or you can select a different chart type for any single data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.), which turns the chart into a combination chart. For bubble charts and most 3-D charts, you can only change the chart type of the entire chart.

  1. Do one of the following:
  2. On the Chart menu, click Chart Type.
  3. On the Standard Types tab, in the Chart type list, click the chart type that you want.

For more information about the chart types that you can use, see Available chart types.

  1. If you are changing the chart type of a single data series only and not the entire chart, be sure that the Apply to selection check box is selected.

 Note   You can only change the chart type of one data series at a time. To change the chart type of more than one data series in the chart, you must repeat all of the steps in this procedure for each data series.

Tips

  • For 3-D bar and column charts, you can change a data series to a cone, cylinder, or pyramid chart type by clicking Cylinder, Cone, or Pyramid in the Chart type list.
  • If you use a specific chart type frequently when you create a chart, you may want to set that chart type as the default chart.

ShowChange the default chart type

  1. Click anywhere in the chart area (chart area: The entire chart and all its elements.) to select the chart.
  2. On the Chart menu, click Chart Type.
  3. On the Standard Types tab or Custom Types tab, in the Chart type list, click the chart type that you want or accept the current selection, and then click Set As Default Chart.
  4. Click Yes, and then click OK.
  5. If the Add Custom Chart Type dialog box appears, type a name in the Name box and a description in the Description box, and then click OK.
 
 
Applies to:
Excel 2003