Simple combination chart

Excel 2016
Sometimes you want to show a single chart with a series of different chart types. These charts containing data series with different chart types for each of them (lines, columns, areas, scatter, etc.) are called combo or combination charts:
Combination chart in Excel 365

Not all the available chart types in Excel can be displayed on a single combo chart. For example, you cannot use bar and column data series in the same chart or combine a pie chart with any other type than a donut.

For example, you can have two different volumes (e.g., the Volume of sales and the product Price), and you want to see them in one chart:

Data range in Excel 365

To create one chart for this data, follow these steps:

   1.   Select the data range (in this example, cells B3:E13).

   2.   On the Insert tab, in the Charts group, click the Insert Combo Chart button:

Combo charts in Excel 365

From the Insert Combo Chart list, choose Clustered Column - Line in Secondary Axis:

Clustered Column - Line in Secondary Axis chart in Excel 365

   3.   Modify this chart.

Notes:

  1. If you prefer to use another chart type instead of the one proposed by Excel, do the following:
    • Select the data series your want to change.
    • Right-click the selection and choose Change Series Chart Type... in the popup menu:
      Change Series Chart Type popup in Excel 365
    • In the Change Chart Type dialog box, select the appropriate chart type for the data series:
      Area chart in Excel 365
  2. To add the next data series with another axis, see Combining several charts into one chart.

See also this tip in French: Comment créer le graphique de combinaison simple.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.