Heartwarming Combining Two Charts In Excel

Since Sales Revenue figures are much larger than Product Groups Product Group data will not be visible on same axis.

Combining two charts in excel. One great feature of Excel is Combo Charts which will allow you to combine two different types of charts to contrast data sets. A combo or combination chart is a chart that plots multiple sets of data using two different chart types. If you want to use another axis you can create another chart and add it to your first chart.

Fill in entries for series. Now we have a graph that shows two series of data. At the top of the dialog you will see a couple pre-canned combo charts to get you started and Clustered Column Line is the default.

In such case you have to create the combination of the two chart types manually. Our table example is very simple we will combine revenue expenses and profit. Create a chart sheet that you want to place all embedded charts into it.

Combine Two Chart Types in Excel. As before click Add and the Edit Series dialog pops up. If you need to create a chart that contains only one primary and one secondary axes see Using two axes in the one chart.

Step by step how to combine two charts 1 - Create your table with the data you want to combine. You need to combine several charts into one chart. The process will move the target data onto a secondary axis.

You will have a graph that looks like below. You can easily create a chart like this one or convert an existing chart into a Combo Chart by following the steps below. First set up a normal stacked column chart with all the data in it also the data for the line chart.