Excel Combo Chart: How to Add a Secondary Axis

Рет қаралды 257,141

Күн бұрын

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

Пікірлер: 58

@MrRajnishdwivedi 3 жыл бұрын

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

@HeadBeeGuy 2 жыл бұрын

Super helpful! Thank you for this video.

@lankylankster7148 2 жыл бұрын

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 2 жыл бұрын

Cheers - glad it was helpful.

@robl417 Жыл бұрын

Very helpful. Thank you.

@EdwinKG 4 жыл бұрын

Thank you, for helping.

@eric_andrews 3 жыл бұрын

My pleasure edwin!

@funny__bean 3 ай бұрын

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

@FRANKWHITE1996 2 жыл бұрын

Exactly what i needed today. Thanks 🙌

@eric_andrews 2 жыл бұрын

Great to hear it 👊

@suzy5166 4 жыл бұрын

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

@eric_andrews 3 жыл бұрын

My pleasure - thanks for checking it out!

@cursodeexcelonline 6 жыл бұрын

Very good Eric

@eric_andrews 6 жыл бұрын

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

@lawrencekazibwe9751 2 жыл бұрын

Thanks alot Boss, very informative

@eric_andrews 2 жыл бұрын

you got it, glad it was helpful

@barbaramillet4544 4 жыл бұрын

Thank you, Thank you, Thank you!

@eric_andrews 4 жыл бұрын

You are so welcome!

@abdullahalmamun-kk5bb Жыл бұрын

so helpful

@youssrael2527 4 жыл бұрын

Thank you so much

@eric_andrews 4 жыл бұрын

You're most welcome

@robertkostka2035 11 ай бұрын

I was looking for scaling... thank you!

@eric_andrews 8 ай бұрын

Glad I could help!

@joelong4650 2 жыл бұрын

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.

@babatundekozeem1649 5 жыл бұрын

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 3 жыл бұрын

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!

@antoniobacic5674 Жыл бұрын

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

@eric_andrews Жыл бұрын

Haha, you are very welcome!

@videovoice4622 2 жыл бұрын

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

@eric_andrews 2 жыл бұрын

You're welcome!

@vladimirmoravek6749 2 жыл бұрын

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.

@docdaven 3 жыл бұрын

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)

@amiramedhat3107 3 жыл бұрын

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..

@thmagd 5 жыл бұрын

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 3 жыл бұрын

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

@thmagd 3 жыл бұрын

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

@heatherwilson9886 6 жыл бұрын

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 6 жыл бұрын

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!

@celltrey 4 жыл бұрын

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

@midoterminator 4 жыл бұрын

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

@keyurpatel498 3 жыл бұрын

good video of graph

@eric_andrews 3 жыл бұрын

glad to hear it keyur! cheers!

@keyurpatel498 3 жыл бұрын

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 3 жыл бұрын

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

@nomunacc2235 3 жыл бұрын

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

@querlt 4 жыл бұрын

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.

@jsrockin 4 жыл бұрын

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

@eric_andrews 4 жыл бұрын

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.

@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!

@AADIBAWA 3 жыл бұрын

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

@patrickcordero6673 4 жыл бұрын

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

@eric_andrews 4 жыл бұрын

which feature specificially? I was using excel 2016

@patrickcordero6673 4 жыл бұрын

The combo chart

@eric_andrews 4 жыл бұрын

@@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 4 жыл бұрын

@@eric_andrews oh i see. Thanks