Create a combination chart

Which Office program are you using?

Word

PowerPoint

Excel

Word

To emphasize different kinds of information in a chart, you can combine two or more charts. For example, you can combine a line chart that shows price data with a column chart that shows sales volumes.

A combination chart with a secondary axis

Note: To create a combination chart, you must use a 2-D chart, such as a 2-D Line, 2-D Column, Scatter, or Bubble chart.

  1. On the View menu, click Print Layout.

  2. In the chart, select a data series. For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected.

  3. On the Charts tab, under Change Series Chart Type, click a chart type, and then click the 2-D chart that you want to add to the existing chart.

    Charts tab, Change Series Chart Type group

    Note: To combine charts, you should have more than one data series.

See also

Add a secondary axis to a chart

Chart types

Change a chart

PowerPoint

To emphasize different kinds of information in a chart, you can combine two or more charts. For example, you can combine a line chart that shows price data with a column chart that shows sales volumes.

A combination chart with a secondary axis

Note: To create a combination chart, you must use a 2-D chart, such as a 2-D Line, 2-D Column, Scatter, or Bubble chart.

  1. In the chart, select a data series. For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected.

  2. On the Charts tab, under Change Series Chart Type, click a chart type, and then click the 2-D chart that you want to add to the existing chart.

    Charts tab, Change Series Chart Type group

    Note: To combine charts, you should have more than one data series.

See also

Add a secondary axis to a chart

Chart types

Change a chart

Animate a chart

Excel

To emphasize different kinds of information in a chart, you can combine two or more charts. For example, you can combine a line chart that shows price data with a column chart that shows sales volumes.

A combination chart with a secondary axis

Note: To create a combination chart, you must use a 2-D chart, such as a 2-D Line, 2-D Column, Scatter, or Bubble chart.

  1. In the chart, select a data series. For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected.

  2. On the Charts tab, under Change Series Chart Type, click a chart type, and then click the 2-D chart that you want to add to the existing chart.

    Charts tab, Change Series Chart Type group

    Note: To combine charts, you should have more than one data series.

See also

Add a secondary axis to a chart

Chart types

Change a chart

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×