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.
Пікірлер: 122
@williammcneil15346 жыл бұрын
Thank You Sir, I've wasted the last 2 hours trying to figure this out.
@brentchristensen58777 жыл бұрын
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!
@Profgarrett7 жыл бұрын
You're very welcome -- I'm glad it helped!
@filipstojanovski32213 жыл бұрын
THIS DISCOVERY SAVED MY LIFE. THANK YOU.
@akistepinska7 жыл бұрын
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.
@feldy316837 жыл бұрын
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.
@danielruelas223 жыл бұрын
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
@pranjalm6362Ай бұрын
genuine tutorial video! crisp and concise! Thanks!
@daveplatter76105 жыл бұрын
THANK YOU SO MUCH for this information. I've been trying to figure this out for months. I am grateful.
@tomc.dossantos30675 жыл бұрын
Thank you so much! My master's thesis just got way better because of you.
@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!
@stasallen39234 жыл бұрын
Thank you so much! The fact it's this tedious to do it on Mac is ridiculous.
@lehuang63263 жыл бұрын
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!
@partsplus13954 жыл бұрын
I only like and comment when there is a deserving video. Thank you. This was very helpful and exactly what I was looking for.
@juliacooper91733 жыл бұрын
I have never commented on KZfaq before but this is the most helpful video ever!
@bhagwanmurlimal14073 жыл бұрын
Excellent video. To the point and easy to follow.
@StephenJury7 жыл бұрын
been trying to do this for bloody ages. Thanks for the vid
@The-DIY-Guide6 жыл бұрын
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
@kevbidgood6 жыл бұрын
Well Done! I spent an hour today not being able to do this. THANK YOU for sharing!
@p648625 жыл бұрын
This video is awesome, it explains everything very clearly.
@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
@tranhuechi19957 жыл бұрын
Thank you for this short and effective video!
@rahulpotnis85273 жыл бұрын
Exactly what I was looking for....just amazing....kudos ❤️
@timothymajor70963 жыл бұрын
Thank you so much I have been trying to figure this out for two hours.
@paulinasiwak23436 жыл бұрын
Great explanation. Very clear. Thank you!
@drewgriffin49473 жыл бұрын
Enormously helpful! Thank you so much!!
@AlexisRodrigo6 жыл бұрын
Just what I needed. Thank you very much!
@Chingmy11195 жыл бұрын
Thanks! It's really useful. I first look into the microsoft help and it couldn't help at all, until I got here.
@alejandrarivera22523 жыл бұрын
Genius! Thanks for explaining it so easily!
@fola56211354 жыл бұрын
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,,,
@JuggernawgHD6 жыл бұрын
This is great, really helped me thank you!
@TheDerekSaenz3 жыл бұрын
You have changed my life.
@soujanyaappalla79712 жыл бұрын
Thank you for your Easy Explanation. Great work. Very Helpful
@loistozer4 жыл бұрын
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
@patrickgallagher11612 жыл бұрын
I echo everyone here when I say, thank you sir!
@laurathompson71822 жыл бұрын
This was so helpful literally saved my life thank you so so so much
@samine19946 жыл бұрын
ur brilliant i looked so many places and u saved me thx u sooooo much
@joanaandoh25573 жыл бұрын
Just what I needed, thank you!
@rishabhsharma3294 жыл бұрын
Jusssssst can not thank you enough for this... Thank you.. 🙏 😊
@KasperKubica4 жыл бұрын
THANK YOU YOU JUST SAVED MY LIFE!!!
@marcuschaknova92343 жыл бұрын
thank you so much couldnt find any other videos to show how to do this!
@tjkirk51386 жыл бұрын
This was perfect- thank you.
@katiep26763 жыл бұрын
thanks so much - that has just saved me soo much time
@seanbraun40674 жыл бұрын
lifesaver, that was a brutal Process trying to figure that out
@Iamfatemas6 жыл бұрын
thank you , you have saved my life
@flowerlane4563 жыл бұрын
you are a KING!
@tomvau5 жыл бұрын
Thank you so much! Excellent post!
@sarpdoracebeci3 жыл бұрын
What a great contribution ! Thanks a lot
@yeoweishain34953 жыл бұрын
This was really helpful!! Thanks 😊
@ericbowes13496 жыл бұрын
Thanks for the help! Great vid
@simbakirk15 жыл бұрын
Thanks - very clear and helpful
@manuboudewyn80525 жыл бұрын
Thanks! Really helped me out!
@niravsanghavi52062 ай бұрын
simply awesome, thank you
@sagarpawar28043 жыл бұрын
Found it very easy and useful 👌
@rosysthing22523 жыл бұрын
Thank you. This is very helpful
@rscottdot7 жыл бұрын
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!!!!
@Pocket.Maai.575 жыл бұрын
Thank you very much, you made me so happy
@ollycoto3726 Жыл бұрын
Profgarrett you're the goattttttt. what a goat.
@katarinasladoljev78553 жыл бұрын
Awesome, super helpful, thank you!!! :)
@patrickfitzgerald86256 жыл бұрын
Yes yes yes yess!! Thank you also. It's been so frustrating!
@grubbsgrady962 жыл бұрын
YOU ARE AMAZING
@danbrewgmail6 жыл бұрын
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. :)
@dumengyue2401 Жыл бұрын
so helpfullll! thanks!
@emotionalfish11813 жыл бұрын
Big thank you! I have a meeting in 30 minutes and you saved my @ss!
@sitimahgrizasinaga24364 жыл бұрын
thank youu it's very helpfull❣
@IndiaGamingTimes4 жыл бұрын
Thank you.. very useful
@ricardoguzman54132 жыл бұрын
Thanks sir. Very helpful video
@scotthaldane55446 жыл бұрын
Great help thanks
@MegaSharif20105 жыл бұрын
Rarely comment on videos, but thank you very much!
@j_july21782 жыл бұрын
I love you Man
@alexpaul78673 ай бұрын
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
@AnhPham-wj3bf6 жыл бұрын
THANK YOU SO MUCH SIR
@ldunlap26352 жыл бұрын
THANK YOU!!!
@willmctavish97786 жыл бұрын
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
@Profgarrett6 жыл бұрын
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.
@kalyssatorres83222 ай бұрын
Thank you!!!!!!
@alexispleuvry41075 жыл бұрын
Thank you so much
@timschwettmann78206 жыл бұрын
very nice explanation thanks a lot
@Profgarrett6 жыл бұрын
You're welcome!
@mohammadalhindi75502 жыл бұрын
Thank you sir
@1589Yadavji3 жыл бұрын
Thank you.
@swaggyskye3 жыл бұрын
THANK YOU! This is so frustrating and even Coursera videos won't tell you about this -- really ridiculous
@marianaalarconretana13446 жыл бұрын
¡MUCHAS GRACIAS!
@marieherbstein42323 жыл бұрын
THANK YOU
@jessicathomas98697 жыл бұрын
THANK YOU :D
@amysparks45094 жыл бұрын
Thanks!
@MrBrettharder6 жыл бұрын
Lifesaver
@MeleDrummer5 жыл бұрын
Thank you
@andreeazoica37452 ай бұрын
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.
@Profgarrett2 ай бұрын
Sure, if you want you can add multiple data series, and stack them as a bar chart.
@madhudilru25824 жыл бұрын
Thank u sir
@vladostapovets72094 жыл бұрын
thanks!
@Adam88Marz7 жыл бұрын
thank you.
@potsunade4 жыл бұрын
My legend dosen't have any text, any fix for it?
@olivia89496 жыл бұрын
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?
@Profgarrett6 жыл бұрын
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.
@siripajantabon12753 жыл бұрын
Thank You For How to Combo Chart
@melaniesatterthwaite88594 жыл бұрын
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?
@Profgarrett4 жыл бұрын
Sure, just choose a different data series to be the secondary axis.
@discoveringsaskatchewan4 жыл бұрын
@@Profgarrett Hi, is this possible for a doughnut chart? Can you please show how to make a doughnut chart on mac?
@poppcn7 жыл бұрын
Awesome
@Bouncer1012Ай бұрын
I'd like it twice if I could!
@OfficialHobbitFan6 жыл бұрын
I love you
@alexmendez97922 жыл бұрын
I wish I had thought to look for help on KZfaq 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?
@Profgarrett2 жыл бұрын
This is actually on a Mac, so you should be able to follow along.
@alexmendez97922 жыл бұрын
@@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
@Profgarrett2 жыл бұрын
@@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.
@nathanrowe25246 жыл бұрын
thankyou so much i was having a meltdown because i couldnt do this