Simple combination chart

Excel 2016 2013
Sometimes you want to show a single chart that consists of series that use different chart types.
Combination chart in Excel 365

For example, if you 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:D13).

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

Combo charts in Excel 365

   3.   In the Insert Combo Chart list, choose Clustered Column - Line in Secondary Axis:

Clustered Column - Line in Secondary Axis chart in Excel 365

   4.   Modify this chart.

Notes:

  1. If you prefer to use another chart type instead of proposed by Excel, do the following:
    • Select the data series your want to change.
    • Right-click on 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. How 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.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.