Combining several charts into one chart

Excel 365 2016 2013 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.

If you need to create a chart that contains only one primary and one secondary axis, see Using two axes in the one chart.

In this tip we will show how different data series (e.g., volume, price and gross income) could be combined in the one chart.

Several Charts in one in Excel 2010

Excel uses only two axis in one chart: primary and secondary. If you want to use another axis, you can create another chart and add it to you first chart. To do this, follow next steps:

   1.   Select the data range (in this example - gross income in D4:D12):

Data range in Excel 2010

And create a chart that you want:

The Second Chart in Excel 2010

   2.   Delete the horizontal axis and modify vertical axis:

Axis in Excel 2010

To change Axis labes, open the Format Axis dialog box and choose that you want on the Axis Options:

Axis labels in Excel 2010

   3.   Right-click in the chart area, in the popup menu select Format Chart Area... to open the Format Chart Area dialog box:

Format Chart Area in Excel 2010
  • On the Fill tab, select the No fill checkbox.
  • On the Border Color tab, select the No line checkbox.

   4.   Right-click in the plot area, in the popup menu select Format Plot Area... to open the Format Plot Area dialog box. On the Fill tab, select the No fill checkbox.

   5.   The most hard step: Modify first chart to create a space in the right part of the chart and move second chart to create more interesting chart:

Several Charts in Excel 2010

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.