Excel Combo Chart: How to Add a Secondary Axis

This tutorial explains how to create an Excel combo chart (aka dual axis chart) with a secondary vertical axis to visualize two different types of data on the same chart.
👉 Check out my courses to help you master Excel in a weekend: www.ericandrewsstartups.com/c...
____________________________________________
Learning how to build an Excel combo chart (or dual axis chart) is a powerful skill that can help you simplify complex stories around data.
The benefit of a combo chart, compared with a regular chart, is that we can visualize two different data sets on the same chart - for instance - financial ($ denominated) data as well as website conversion rates (% denominated), by adding a secondary vertical axis.
The prerequisite to building an Excel combo chart is that you need to have the right data to visualize. You will have a different type of data on each vertical axis (one on the left and one on the right) but these two types of data will share the horizontal axis.
What this means is that the two types of data need to share the something in common - usually that they happen during the same time (on the horizontal axis) - in order to build an Excel combo chart.
As long as you have the right data, you can add a secondary axis (vertically) and visualize your two data sets one one chart!
By the end of this video you will feel confident creating & adapting dual axis charts and visualizing different types of data. If you have a question - leave me a question in the comments and I'll get back to you!
► Subscribe for more finance & Excel videos: bit.ly/EricAndrewsSubscribe
#excelcombochart #dualaxischart #secondaryaxisexcel

[@lankylankster7148]

THANK YOU, Eric! It helped that you taught how to reposition the horizontal labels to a lower position so they're distinguished from the more visual parts of the graph (vertical bars and horizontal % line). LL

[@eric_andrews]

Cheers - glad it was helpful.

[@MrRajnishdwivedi]

Thank you very very much for such clear and concise explanation 👍!!!!

[@funny__bean]

thank you very much for mentioning the axis title part!!! 💓💓💓💓💓💓💓💓

[@HeadBeeGuy]

Super helpful! Thank you for this video.

[@joelong4650]

I'm trying to put together a line graph comparing five different teams performance on one of our priority metrics. I have a graph depicting their daily performance throughout the month. I would like to add their current average displayed as a dot on the far right side of the chart with the color corresponding with that of their line. I have not found a video with this information so I was wondering if you have a video you could direct me to or any ideas as to how to accomplish this something of a similar effect.

[@robl417]

Very helpful. Thank you.

[@EdwinKG]

Thank you, for helping.

[@eric_andrews]

My pleasure edwin!

[@babatundekozeem1649]

Thanks for the insightful video. I will like to ask if it it possible to have one of say five series to be on the secondary axis (line graph) while the remaining four series remain in a starked column not clustered as you have brilliantly shown in this video. Thanks

[@eric_andrews]

Hey Babatunde - yes, you can have as many series as you want as long as they either correspond with the type of data either the primary or secondary vertical axis. Hope that helps!

[@vladimirmoravek6749]

nice video, is it somehow possible to overlay both X axis? I mean, that when I set up overlay 100% I will still be able to see orange over the blue vertical line.

[@suzy5166]

Thanks very much... very useful... 🙏🙏🙏

[@eric_andrews]

My pleasure - thanks for checking it out!

[@FRANKWHITE1996]

Exactly what i needed today. Thanks 🙌

[@eric_andrews]

Great to hear it 👊

[@cursodeexcelonline]

Very good Eric

[@eric_andrews]

Hi @Curso de Excel Online - my pleasure. Glad it helped!

[@docdaven]

how did you get Sales and Net Profit to show side-by-side? No matter what I do, the bars overlap. All I want is 2-axes both sets with separate bars (no lines) and then, ideally, somehow show it in 3D (though it looks like 2 axes aren't supported in Excel 2013)

[@barbaramillet4544]

Thank you, Thank you, Thank you!

[@eric_andrews]

You are so welcome!

[@celltrey]

hey how do you get to all charts in the new excel

[@thmagd]

Hello Eric, your videos really helps, thanks for uploading. Could you please do the video of how to do an animation with powerpivot, I couldn't find any videos on the internet.

[@eric_andrews]

Hey - really appreciate the suggestion. I'll look into creating a tutorial. Cheers!

[@thmagd]

@@eric_andrews thank you 🙏🏻 let me know if you create it 👩🏻‍💻

[@lawrencekazibwe9751]

Thanks alot Boss, very informative

[@eric_andrews]

you got it, glad it was helpful

[@youssrael2527]

Thank you so much

[@eric_andrews]

You're most welcome

[@robertkostka2035]

I was looking for scaling... thank you!

[@eric_andrews]

Glad I could help!

[@amiramedhat3107]

For some weird reason, the dates don't show up at the bottom of my chart which messes up the chart and i don't know how to fix that..

[@abdullahalmamun-kk5bb]

so helpful

[@midoterminator]

please i have urgent question in charts that stops my work could you help me please

[@heatherwilson9886]

Hey Eric, I have a graph with historical data and projected data. I currently have this as a scatter plot with two sets of data. My boss would like the historical data to be columns, but when I convert the historical data to columns, the historical and projected data overlaps. Anyway to have column and scatter on two separate sets of x values?

[@eric_andrews]

Hi! What you would need to do in this case is add a secondary horizontal axis instead of a secondary vertical axis. It is not super common but it is possible!

[@videovoice4622]

thanks for teaching me how to put the label low!!!

[@eric_andrews]

You're welcome!

[@nomunacc2235]

there is no combo chart type in my chart6. What can i do?

[@querlt]

Hi Eric! Great video! Question: Instead of manually setting a value in "Minimum Bounds" under Axis Options (referring to timestamp 6:43), is there a way to make it automatically adjust properly? Because I find that this method works only if my the data in the combo chart doesn't change.

[@antoniobacic5674]

This helps, thanks a lot. PS Pleasant to listen to.

[@eric_andrews]

Haha, you are very welcome!

[@AADIBAWA]

but how i can create chart if i have more than 500 rows ???

[@jsrockin]

What if I want conversion rate axis on left and money on left side

[@eric_andrews]

Hi jsrockin - that's easy. At 2:14, just click the "Secondary axis" box for Sales and Net Profit (money) and leave the Conversion Rate box unchecked. That would swap the axis.

[@keyurpatel498]

good video of graph

[@eric_andrews]

glad to hear it keyur! cheers!

[@keyurpatel498]

can you give me advise how to compare two graph as an example like one for company occupancy % and second is that occupancy change in %

[@keyurpatel498]

i need one more support if need to involve more axis hand

[@jonpetter8921]

What if we add a fourth axis about temperatur (celcius)for instance.

[@eric_andrews]

I'm not sure! I don't think it is possible in Excel, or at least I don't know a way. Would be useful!

[@patrickcordero6673]

my 2010 excel doesn't have this deature? what is your version?

[@eric_andrews]

which feature specificially? I was using excel 2016

[@patrickcordero6673]

The combo chart

[@eric_andrews]

@@patrickcordero6673 so I just googled "combo chart excel 2010" and it looks like your version should have the feature. You'll need to try to change the series type from primary to secondary. Maybe just google it, as I think that version of Excel might have a slightly different layout, and make sure to include either "windows" or "mac" when you search. So I can't be of more help!

[@patrickcordero6673]

@@eric_andrews oh i see. Thanks

[@ghazalahashmi9215]

I don't understand

[@eric_andrews]

Hi do you have a specific question?