Simple combination chart

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

For example, if you have two different volumes (e.g., volume of sales in unit A and in unit B) and you want to see in one chart the dynamic of their sales:

Data range in Excel 2016

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

   1.   Select the data range (in this example - cells B4:D13).

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

Combo charts in Excel 2016

   3.   In the proposed list choose Clustered Column - Line in Secondary Axis.

   4.   Modify this chart.

How to add 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.