Create a combination chart

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.

Word

  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 Chart Design tab, click Change Chart Type and then click the 2-D chart that you want to add to the existing chart.

    Choose a chart type

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

PowerPoint

  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 Chart Design tab, click Change Chart Type and then click the 2-D chart that you want to add to the existing chart.

    Choose a chart type

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

Excel

  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 Chart Design tab, click Change Chart Type and then click the 2-D chart that you want to add to the existing chart.

    Choose a chart type

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

Word

  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

  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 text, objects, and charts in PowerPoint for Mac

Excel

  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

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×