Office
Sign in

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.

Note:  To complete this procedure, you must have an existing chart. For more information about how to create a chart, see Create a chart from start to finish.

  1. Do one of the following:

    • To change the chart type of the whole chart, click the chart area or plot area of the chart to display the chart tools.

      Tip: Alternatively, right-click the chart area or plot area, click Change Chart Type, and then continue with step 3.

    • To change the chart type of a data series, click that data series.

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

    This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  2. On the Design tab, in the Type group, click Change Chart Type.

    Excel Ribbon Image

  3. In the Change Chart Type dialog box, click a chart type that you want to use.

    The first box shows a list of chart type categories, and the second box shows the available chart types for each chart type category. For more information about the chart types that you can use, see Available chart types.

Note:  To complete this procedure, you must have an existing chart. For more information about how to create a chart, see Create a chart from start to finish.

  1. This step applies to Word 2016 for Mac only: 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.

  1. This step applies to Word for Mac 2011 only: 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

Video: Combine two or more chart types in a chart

Animate text, objects, and charts in PowerPoint for Mac

Expand your Office 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.

×