3 minute Combo Chart with Excel for Mac

Creating a combo chart with both columns and lines takes a few extra steps. This video walks you through some of the most common problems.

[@williammcneil1534]

Thank You Sir, I've wasted the last 2 hours trying to figure this out.

[@brentchristensen5877]

You, Sir are a genius. I looked EVERYWHERE to try to figure out how to do a "combo" or "secondary axis" chart in Excel 2016 for Mac, and NO ONE had the right answer - even on the Microsoft Excel for Mac forums! Thank you for posting this!

[@Profgarrett]

You're very welcome -- I'm glad it helped!

[@pranjalm6362]

genuine tutorial video! crisp and concise! Thanks!

[@filipstojanovski3221]

THIS DISCOVERY SAVED MY LIFE. THANK YOU.

[@akistepinska]

I have a Excel 2016 for Mac and have been searching for this solution a bit. This tutorial is exactly what I needed - creating a combo chart and displaying percentages. Thank you.

[@feldy31683]

Nice tutorial! I just picked up a MacBook and installed Excel on it. This is something I knew how to do on traditional PCs but didn't know the steps on a Mac. Appreciate you putting this together.

[@danielruelas22]

ive been watching videos for like an hour and a half trying to do this, and this showed me how in 3 minutes. THANK YOU

[@daveplatter7610]

THANK YOU SO MUCH for this information. I've been trying to figure this out for months. I am grateful.

[@tomc.dossantos3067]

Thank you so much! My master's thesis just got way better because of you.

[@lehuang6326]

thank you for posting this! my professor posted the tutorial for PC and I thought I was doing something wrong. short and to the point!

[@deliciousasmrtimes5207]

THANK YOU SO MUCH!!!!! You have no idea how helpful this video is to me cuz this is the only video I found that covered this issue for Mac!

[@soujanyaappalla7971]

Thank you for your Easy Explanation. Great work. Very Helpful

[@juliacooper9173]

I have never commented on KZbin before but this is the most helpful video ever!

[@partsplus1395]

I only like and comment when there is a deserving video. Thank you. This was very helpful and exactly what I was looking for.

[@StephenJury]

been trying to do this for bloody ages. Thanks for the vid

[@stasallen3923]

Thank you so much! The fact it's this tedious to do it on Mac is ridiculous.

[@kevbidgood]

Well Done! I spent an hour today not being able to do this. THANK YOU for sharing!

[@vanlongnguyen7682]

Thank you very much sirrrr. I've gotten so confused when my teacher use window to teach me this. So glad to find you, good day

[@bhagwanmurlimal1407]

Excellent video. To the point and easy to follow.

[@The-DIY-Guide]

suggestion: add in description or title "how to make a secondary axis in mac 2016 excel" thats what everyone searches and seriously the only correct answer after looking for hours is this. thank you so much

[@loistozer]

Amazing, clear and precise, and as Brent below says, better than MS's own hopeless solution, that directs you from Excel into Word. I mean... tut. Thanks so much

[@p64862]

This video is awesome, it explains everything very clearly.

[@patrickgallagher1161]

I echo everyone here when I say, thank you sir!

[@Chingmy1119]

Thanks! It's really useful. I first look into the microsoft help and it couldn't help at all, until I got here.

[@tranhuechi1995]

Thank you for this short and effective video!

[@paulinasiwak2343]

Great explanation. Very clear. Thank you!

[@katiep2676]

thanks so much - that has just saved me soo much time

[@rahulpotnis8527]

Exactly what I was looking for....just amazing....kudos ❤️

[@timothymajor7096]

Thank you so much I have been trying to figure this out for two hours.

[@TheDerekSaenz]

You have changed my life.

[@alejandrarivera2252]

Genius! Thanks for explaining it so easily!

[@fola5621135]

you have no idea how this was helpful , thank you very much

[@Heyyougyogirl]

Thank you so much!!!!!!! i've been searching for this almost 2hours,,,

[@AlexisRodrigo]

Just what I needed. Thank you very much!

[@drewgriffin4947]

Enormously helpful! Thank you so much!!

[@niravsanghavi5206]

simply awesome, thank you

[@JuggernawgHD]

This is great, really helped me thank you!

[@seanbraun4067]

lifesaver, that was a brutal Process trying to figure that out

[@samine1994]

ur brilliant i looked so many places and u saved me thx u sooooo much

[@ollycoto3726]

Profgarrett you're the goattttttt. what a goat.

[@rscottdot]

Thank you for this 3 minute video! I spent hours trying to update a combo chart created in Excel 2013. After your video, not only was I able to update the chart, but now it looks much better than it did in Excel 2013....in 3 minutes. Thank you, thank you, thank you!!!!

[@tjkirk5138]

This was perfect- thank you.

[@marcuschaknova9234]

thank you so much couldnt find any other videos to show how to do this!

[@rishabhsharma329]

Jusssssst can not thank you enough for this... Thank you.. 🙏 😊

[@laurathompson7182]

This was so helpful literally saved my life thank you so so so much

[@KasperKubica]

THANK YOU YOU JUST SAVED MY LIFE!!!

[@joanaandoh2557]

Just what I needed, thank you!

[@patrickfitzgerald8625]

Yes yes yes yess!! Thank you also. It's been so frustrating!

[@tomvau]

Thank you so much! Excellent post!

[@Iamfatemas]

thank you , you have saved my life

[@sarpdoracebeci]

What a great contribution ! Thanks a lot

[@simbakirk1]

Thanks - very clear and helpful

[@ericbowes1349]

Thanks for the help! Great vid

[@danbrewgmail]

Awesome, thanks! Like my Mac, but there are some things that are much easier to do on a Windows machine. This trick will let me carry my Mac for those long road trips. :)

[@manuboudewyn8052]

Thanks! Really helped me out!

[@sagarpawar2804]

Found it very easy and useful 👌

[@flowerlane456]

you are a KING!

[@rosysthing2252]

Thank you. This is very helpful

[@Pocket.Maai.57]

Thank you very much, you made me so happy

[@yeoweishain3495]

This was really helpful!! Thanks 😊

[@katarinasladoljev7855]

Awesome, super helpful, thank you!!! :)

[@emotionalfish1181]

Big thank you! I have a meeting in 30 minutes and you saved my @ss!

[@alexpaul7867]

Very useful - thank you for your help! I don't know why stuff has to be so hidden on macbook excel - I use a lenovo for work

[@IndiaGamingTimes]

Thank you.. very useful

[@ricardoguzman5413]

Thanks sir. Very helpful video

[@MegaSharif2010]

Rarely comment on videos, but thank you very much!

[@sitimahgrizasinaga2436]

thank youu it's very helpfull❣

[@scotthaldane5544]

Great help thanks

[@dumengyue2401]

so helpfullll! thanks!

[@AnhPham-wj3bf]

THANK YOU SO MUCH SIR

[@grubbsgrady96]

YOU ARE AMAZING

[@marianaalarconretana1344]

¡MUCHAS GRACIAS!

[@ldunlap2635]

THANK YOU!!!

[@andreeazoica3745]

Very helpful, thanks for this. Is that possible to do the same graph in which to introduce data per year too? For example, for each area to add data from the last 3 years. Comparing the sales and margin for the same area for the last 3 years.

[@Profgarrett]

Sure, if you want you can add multiple data series, and stack them as a bar chart.

[@alexispleuvry4107]

Thank you so much

[@mohammadalhindi7550]

Thank you sir

[@Pandaluver67899]

Thank you!!!!!

[@1589Yadavji]

Thank you.

[@timschwettmann7820]

very nice explanation thanks a lot

[@Profgarrett]

You're welcome!

[@willmctavish9778]

Thanks for the great video. I've found this only works with the 2D graphs. When I change the data series to line graph when I have the chart setup as a 3rd cluster, it changes the whole chart, but when it's 2D, it works. Any ideas what I might be doing wrong? Thanks Will

[@Profgarrett]

You're not doing anything wrong; I have the same result on my own computer. Unfortunately, Excel isn't able to do combo charts with 3d.

[@marieherbstein4232]

THANK YOU

[@j_july2178]

I love you Man

[@jessicathomas9869]

THANK YOU :D

[@MrBrettharder]

Lifesaver

[@Adam88Marz]

thank you.

[@MeleDrummer]

Thank you

[@siripajantabon1275]

Thank You For How to Combo Chart

[@amysparks4509]

Thanks!

[@madhudilru2582]

Thank u sir

[@swaggyskye]

THANK YOU! This is so frustrating and even Coursera videos won't tell you about this -- really ridiculous

[@poppcn]

Awesome

[@vladostapovets7209]

thanks!

[@Bouncer1012]

I'd like it twice if I could!

[@nathanrowe2524]

thankyou so much i was having a meltdown because i couldnt do this

[@melaniesatterthwaite8859]

Hi Is it possible to switch the y axis over so in your example percentage would be on the primary axis and values on the secondary?

[@Profgarrett]

Sure, just choose a different data series to be the secondary axis.

[@discoveringsaskatchewan]

@@Profgarrett Hi, is this possible for a doughnut chart? Can you please show how to make a doughnut chart on mac?

[@olivia8949]

What do I do when the data sets I want in my combination set aren’t next to each other? How do I select multiple sets of data that are in seperate areas of my spreadsheet?

[@Profgarrett]

You can use the "select data" ribbon option to choose data in different parts of your worksheet. This is pretty annoying though, you may have an easiest time just copying+pasting the data into a single location.

[@potsunade]

My legend dosen't have any text, any fix for it?

[@OfficialHobbitFan]

I love you

[@alexmendez9792]

I wish I had thought to look for help on KZbin sooner... I thought my error was on the way I was laying out the data and I rearranged the table in SO many ways... Now, is there still not a way to do dynamic charts (like the one on this video) on Mac?

[@Profgarrett]

This is actually on a Mac, so you should be able to follow along.

[@alexmendez9792]

@@Profgarrett yeah. But I meant those bar charts where a drop down menu appears in the actual graph and you can manipulate the data with filters. I think they’re called dynamic graphs

[@Profgarrett]

@@alexmendez9792 Ah, I see that you're talking about now. I'm familiar with those when using Pivot Charts, but haven't done anything with regular charts using a dynamic input.

[@The-DIY-Guide]

finally