Combining several charts into one chart

If you need to create a chart that contains only one primary and one secondary axes, see Using two axes in the one chart.
Excel uses only two axes in one chart: primary and secondary. If you want to use another axis, you can create another chart and add it to your first chart. To do this, follow the next steps:
1. Select the data range (in this example, B5:B13 and E5:E13):

And create a chart that you want. For example:

2. Delete the horizontal axis and modify the vertical axis:

3. Right-click on the chart area and choose Format Chart Area... in the popup menu:

4. On the Format Chart Area pane:
- In the Fill section, select the No fill checkbox,
- In the Border section, select the No line checkbox:

5. If necessary, right-click on the chart plot area and choose Format Plot Area... in the popup menu. On the Format Plot Area pane:
- In the Fill section, select the No fill checkbox,
- In the Border section, select the No line checkbox.
6. The hardest step: Modify the first chart to create a space in the right part of the chart and move the second chart to create a more interesting chart:

See also this tip in French: Comment combiner plusieurs graphiques dans le graphique.