Create a Combination Chart in Excel

Ever see those charts where there is a column chart and a line chart in one? It's sort of like a someone was able to add a chart to another chart. Also there are two axis that show ranges on values on both the left and right side of the chart? Well this is called a combination chart or (combo chart or dual axis chart) and it's commonly used to show two series of data together. Or it's trying to combine two graphs (or two charts) together. I see this most in stock price type of charts where the column charts shows the volume of stock trading activity and the line chart shows the stock price. You might think that to create this custom combo chart would take some effort, but it's actually fairly easy to create by adding a secondary axis to the chart. Though it's not really trying to merge two graphs together, it's a great way to show multiple views of data in one chart. See the video to learn how it's done.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[arnetmitarnetmit]

I made lots of article using this video. thank you so much Doug from Turkey.

[dilahalida]

I spend about 1 hour to create the 2nd graph...by this video I complete it with just a few seconds...thank you so much

[daniellechibuye]

You just saved my life.i spent a whole week trying to figure out how to get a secondary axis. Thank you so much!!!

[lyndapartner]

thanks for the help - way better than anything else on the internet

[darlenezubik]

Thank you Doug! Better at explaining than Microsoft!

[auroramboya]

Thanks Doug I've been wanting to create 2-in-1 graphs seamlessly

[mukesh]

It is very easy to understand by explain each step excel many thank to all

[nstigr]

Thank YOU!  Just what I needed to change a chart type in a series!  I'm grateful for your video!

[avitovaz]

I was struggling how to create a combination chart in MS 2010. Sir, you made it easy. Tons of Thanks

[to_paradise_and_beyond]

Nice and clear explanation, thanks a lot.

[Srin]

This really usefull for reminding me.. thank so much.

[awlonghurst]

Excellent explanation of Excel charts. Thank you very much.

[Samfid]

Totally helped. Never would have figured that out myself

[brianmateos]

Great presentation, thank you very much

[himanshudalai]

Thank you so much Doug. It is really very helpful.

[jhype]

This was really helpful. Thanks so much!

[elizap]

Can this be used for 2016 Excel? I need to make one of these right away, but it's Windows 10.

[arthuraliku]

very nicely done. I found it very helpful

[MNSTRMDVNCS]

You saved me so much time with this!
Thanks a lot!

[sosheelgodfrey]

Hi Doug, I want to use specific values on my horizontal or x-axis in excel 2013 scatter plot. I have these number values in my excel sheet column but the scatter plot picks some values itself automatically. How can I use the exact value that I have ? Please help. Thanks