Combining several charts into one chart

Excel 2016 2013 2010 2007 2003
If you want to combine more than two different data series with common horizontal and different vertical values, you could not just add another axis to the chart. You need to combine several charts into one chart.
Several Charts in one in Excel 365

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, B3:B13 and E3:E13):

Data range in Excel 365

And create a chart that you want. For example:

The Second Chart in Excel 365

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

   2.1.   To delete the horizontal axis, select it and press Delete.

   2.2.   Right-click the horizontal axis and choose Format Axis... in the popup menu (or double-click the axis):

Format Axis in popup Excel 365

On the Format Axis pane, on the Axis Options tab, in the Labels group, in the Label Position list, choose High to display the axis labels on the right side:

Format Axis in popup Excel 365

Make other adjustments to get the style you want:

The Second Chart in Excel 365

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

Format Chart Area in popup Excel 365

   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:
Format Chart Area in Excel 365

   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:

Several Charts in Excel 365

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

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