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.