Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

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 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.

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

See Also

Add a secondary axis to a chart

Chart types

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×