Progress Chart: Excel Clustered Column Chart with Overlapping Bars

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/covid-chart-file

[@chh8860]

It's Thursday morning (5:14AM) with Leila … hot black coffee … with a few Christmas Holiday baking treats. Remarkably … I had a reasonably good idea how to approach the proposed problem … only because I have watched Leila's other KZbin videos and have taken her courses. The main difference is she did in 7 minutes what would still take me 7 hours … but that is so much better than a year ago. The Power Point tip was the 'major takeaway' for me … quite clever (but no surprise that I would learn it from Leila). Season Greetings ... and Happy Holidays … and thank you for your wonderful work!

[@LeilaGharani]

Thank you! I’m also having my coffee now with a bit of milk (black is only in the morning) and enjoying some Christmas cookies.i’m glad you found the PowerPoint tip useful. Wish you a wonderful Christmas time.

[@AccountingandQuickbooks]

Very Nice and useful thanks for sharing Leila

[@thedavidseatonshow]

Thank you for the early Christmas gift. Especially helpful is copying the HEX code from the website to copy the original colors. Merry Christmas!

[@LeilaGharani]

Thank you! Glad you found that useful. And merry Christmas to you too.

[@VishwaManava_Sri]

Highly appreciate your humbleness in taking viewers requests and questions seriously. also appreciate the efforts your applying in resolving, educating, enriching, and enhancing our excel skill. Happy Christmas, May God Bess You.

[@LeilaGharani]

Thank you for your kind comment and support. Happy holidays to you too 😊

[@michaelround8054]

Great video, as always, with a couple of specific take-aways! And the comment about "Stop and try to figure this out - you'll find something new doing this" was spot on!

[@LeilaGharani]

Glad you found some takeaways from this Michael. Thank you for your comment.

[@jeffmcdowell2716]

Leila, I love your stuff, on this one I was surprised you didn't catch and stop the non- Tufte-ness of this chart idea.

[@wannabedal-adx458]

Good video. I had to do something like this several years ago for a work task, show total number of tasks assigned and then a subset of those completed in an overlapping bar chart. In some circles this is called a thermometer chart. The only confusing parts in the video was why even need the pale background bars behind the "yes" and "no" and how and why switch the 100% background bars from the secondary axis to the primary axis.

[@adan8657]

This demostrates why many times, when working with Power BI, I miss Excel

[@rob4canada]

I wouldn't have thought of making background bars the primary axis. I would have kept them on the second axis and made them transparent. I like this method much more. Thanks for another great video.

[@khalidrehman5045]

Thanks LG for another great video, thumbs up 👍

[@LeilaGharani]

Thanks for watching

[@Excelambda]

Added to my special collection of excel charts tutorials!!!🎄🎄🎁🎁

[@deepashankar08]

Going to use the color palette for my charts going forward, looks very professional and neat

[@LeilaGharani]

Hope it will be helpful for you.

[@mcd22630]

I just figured out why Ms Gharani is better than Santa Claus. Santa brings a gift once a year. Ms Gharani bring a gift once, sometimes twice, a week! Merry Christmas everyone.

[@LeilaGharani]

Ahhh thank you! Wish you a merry Christmas 🎄.

[@hugojoelalatorregodoy9219]

Merry Christmas Leila, your videos are very useful and your pedagogy is incredible. Thank you from Sonora Mexico, for sharing your knowledge.

[@LeilaGharani]

Thank you and merry Christmas to you too!

[@shakthiatukorala595]

Nice tutorial..Nicely explained. Every tutorial of yours has new thing to learn...hopefully waiting for new one. Thanks.

[@LeilaGharani]

Thank you very much!

[@thamilanban]

Thank you Leila. Wish you a Happy Christmas!

[@LeilaGharani]

Thank you! Same to you!

[@TheMacShihab]

It’s a great video, but I think you may have missed the step of fixing the axis for the dataset to (0,100) the same way you did it for the background bars (0%,100%).

[@kendrumusic5554]

Yeah they’re not at scale ie Overall 72 is too high (at 5:06 we can see it’s at approx 80%)

[@v2pumo817]

Yes right scale should be from 0 to 100%...

[@VipulKarkar]

Exactly. It gave me anxiety when she hide that axis without fixing it. I was hoping that she will fix it in the end of the video but she didn't. :) but overall a great way to recreate the charts that we see online. Keep it up Leila.

[@roberth.9558]

Absolutely brilliant, Leila. Thank you as always.

[@excelworx8712]

Bar-in-bar chart. Very good to see things in perspective. Well done Leila. Happy Xmas

[@sjn7220]

Very nice. If you insert the text box or shape inside the chart there is no need to group it with the chart, it will stay with it.

[@Dylan-zm3ht]

Great production quality!!!

[@naibahmadzada2041]

Can you start the Stock Market video, please? Because we can say you teach us more account information than our school. That's why we love you. Thank You

[@tkhobbes]

I like your idea very much, and I didn't know about the "order" of the primary and sexondary axis. Nice thanks for sharing! However I think the original chart is not a very good one. It uses too much "ink" - there's no point in my view to plot "yes/no" on two different bars, as together, they (with a possible third option of "no answer") will always sum up to 100%... so just stack them on top of each other would be much easier?

[@mfzasr5665]

Nice attempt. You should have set 100 as the maximum value of the secondary axis. The chart you produced,the primary axis has 100% as maximum value and 90 as the maximum in the secondary axis

[@wayneedmondson1065]

Hi Leila. Great lesson! Nice effects and especially like the tip on color matching using PowerPoint and the eyedropper.. excellent! Thanks for sharing :)) Thumbs up and Happy New Year!!

[@LeilaGharani]

Many thanks Wayne! Happy new year to you too!

[@MrsCathT]

Thank you Leila for this very neat and clean look chart! Love the HEX trick too, Happy Holidays🎄💕🎄

[@LeilaGharani]

Happy holidays!

[@Luciano_mp]

Nice.Thank you Leila!👍

[@LeilaGharani]

Thank you too!

[@tyo101]

Thanks, Leila! Happy holidays!

[@HachiAdachi]

Instead of grouping the chart and a text box (and/or a color bar in the legend), you could simply select the chart first, then insert a text box (or a rectangle) within the chart. The text box will be part of the chart, and will move with the chart. (You actually do this in the video, and I believe you shouldn't have needed to do that... The color bar in the legend, however, was drawn outside of the chart, so it needed to be grouped, but had it been drawn inside the chart while selected, it would have been part of the chart as well, I believe). Just my 2 cents. Happy Holidays, Leila! 🎉

[@luisneto2165]

I wish you a Merry Christmas, Leila Gharani. Thanks for a lot of useful (in)formation.

[@LeilaGharani]

Thank you for all your support Luis. Merry Christmas to you too.

[@nsanch0181]

That is a nice looking chart and thank you for showing how to make it. I just finished your Power Query course on Udemy. It was excellent.

[@LeilaGharani]

I’m glad you’re enjoying the course 😊

[@florincopaci6821]

Thank you for this video!

[@HusseinKorish]

Very clever … thanks Leila

[@growth2509]

Very interesting. It demonstrates to me that the Microsoft applications complement one another, as PowerPoint helped out.

[@yulinliu850]

Happy holidays!

[@LeilaGharani]

Thank you. Happy holidays to you too Yulin.

[@ExcelExciting]

Awesome 👍🏻

[@LeilaGharani]

Thanks 🤗

[@jatinkumar3963]

thanks for help us in excel solve complex problem.

[@bashirmoustafa6116]

Amazing,, thank you 👍

[@markpodesta4605]

Thank you Leila. I hope 2021 will be a much better year than this one.

[@vishalkashyap3456]

You are awesome! Excel Queen 👍

[@eduardomunoz2764]

Wonderful, thanks.

[@cdyard1]

Great video. A big Thank you.

[@LeilaGharani]

You’re very welcome Claire.

[@terrymadeley]

Windows V? Wow, that's great.

[@LeilaGharani]

Since I discovered it, I use it everyday 😊

[@salimayoub8181]

Aawesome, thank you leila

[@44.7b.kaharaditya6]

Great video

[@AliciaMarkoe]

Very nice!

[@kofimensah6566]

Awesome! Thx. What if i want to add "overall" and "men" to the first set of grouped bars, how do i do that?

[@WasanthaKumara]

Awesome 👍

[@rickymckenzie9932]

You're always my Idol!

[@oladaposiyanbola8471]

You are good!

[@martik778]

Why does excel treat the 1st column values as a horizontal series when they are text but as a another series column when numeric?

[@kgfes]

Thanks Leila. If the data available is individual patients with dates diagnosis how do you display it individuaks diagnosed per week? As in group in weeks to demonstrate weekly changes

[@pardeeparya9986]

Great👍👍👍

[@krishnasatyawiananda984]

Can we do the same thing to pivot table?

[@szisziszilvi]

Why not simply use the percentige version of the bar chart? Cant recall the name, but i would not need the second axis in that case.

[@surajnirankari7623]

Yes u did it 😊👍

[@9160545460]

thank you...

[@GeertDelmulle]

So, the series on the secondary axis are always on top of the ones on the primary axis, eh?

[@ikramfender]

The 1st time Ive seen usage of clipboard

[@LeilaGharani]

It's so convenient! Since I found it I use it all the time.

[@kapitanknuthansen488]

ur perfect !

[@RobertNairn]

Nice

[@aminghanooni4240]

Windows + V does not work in Windows 10. Any suggestion?

[@hosseinhosseinpoor4845]

thanks..

[@rabihel-habta313]

can you teach or make videos on VBA? thank you.

[@LeilaGharani]

Check out my playlist on Excel VBA. You'll find it on the channel page under playlists.

[@imranaziz22]

Good evening mam . I need your help on pull stock market data in execl . I very thankful to you

[@LeilaGharani]

Hi. I'll have a video on this on Thursday :)

[@imranaziz22]

@@LeilaGharani thanks

[@sidrajawaid3411]

I replicated the chart , but for me horizontal page lines are coming in the chart .. how do i get rid of them..? I wish i could add a pic here

[@LeilaGharani]

I think these might be the gridlines. Select them - just click on one of the them and then press the delete key on the keyboard.

[@sidrajawaid3411]

@@LeilaGharani yayy done . Thanksss alot ♡♡♡

[@ePadhai]

👍

[@KnightsMultiMediaCapeTown]

I have a how do you: If you have a classroom with 30 kids and you want to know the top 3 marks automatically and or the lowest 3 marks, how would you do that???

[@borstenpinsel]

The top 3 marks or the top 3 pupils? And what if 5 pupils have the highest mark? You can get a sorted list of all marks with sort(unique(range)) and then simply take the first 3 lines of the spill-range. If you don't have the new excel 365 functions, it's more tricky sadly.

[@KnightsMultiMediaCapeTown]

@@borstenpinsel Lets say a school whats to give certificate to the top 3 pupils for their marks, or if you wanted to top 10 best sold items according to profit and not item quantity, Yes 365 is good

[@victor-mihailpopescu1027]

Not first!

[@tomdoe1234]

What new normal? Is the Spanish flu still around? By next fall nearly everybody will either of had it or been vaccinated for it. Sure it will mutate but viruses tend to mutate into less deadly forms. Not good for a virus if you’re dead you can’t spread it if you’re dead. Spanish flu where is it?