Simple combination chart

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.