Combining Two Chart
For combining two chart into a single one in excel , you just need to know a couple of small tricks. Here is how it is done…
Lets say we have a company which launches new product groups every couple of months throughout all year. We want to see how our sales revenue is affected by each new launch but prefer to have our information in a single chart. Here is how to do it:
Our monthly data looks like below:
For starters, select all the data and from insert menu, insert column graph. You will have a graph that looks like below:
Now we have a graph that shows two series of data; Sales Revenue and Number of Product Groups. Since Sales Revenue figures are much larger than Product Groups, Product Group data will not be visible on same axis. Therefore we need set a different axis for Product Group data series in order to make them visible. To do this, right click on Number of Product Groups data series on the chart or in the legend (for this example on the legend since it is nor visible on the chart) and select “Format Data Series” from menu.
On the menu you will see, select “Secondary Axis” option and press close button.
Now we have our Product Group data shown on a second, more appropriately scaled axis on the right side. Yet you will see that both data series are positioned on top of each other. So our chart is still no good.
But there is no need to worry. With a single easy move, we will have our chart cooked. Now that we have our two series on different axis’, select Product Group series and from chart tools menu on top of the ribbon, select “Change Chart Type”. Select “Line” as chart type for this series and you are done. This is what your finished chart look like, do some formatting if you like and it is ready for serving.
Download example workbook to check it yourself.