Another beautiful presentation. Ur video clips are always clear and to the point. Another chart type to learn for my dashboards. Thank u from sunny Wigan 😎
Hi Mynda, really useful and clever tutorial which is clearly explained. Thank you. With regard to your source data you could consider copy and "paste as linked picture".
Thanks, Paul! Yes, absolutely use Linked Pictures if you prefer. I find they sometimes look a bit blurry, so I usually prefer to put my workings on another sheet.
An easily overlooked strategy would be number formatting. That can change both the colour and the symbol; I let democrats code to 1, republicans to 2 and other seats 0. The prettiest results might be the scatter chart though. I enjoyed your solutions though and the array functions have the advantage of being dynamic.
Is there anything you can't do in Excel? Everytime I watch your videos my doubts grow stronger :-) BTW, thank you for your tip on fixing conditional format rules. Now they work fine and pasting as values have become my personal matra, too!
Great stuff, although the chart is dynamic, the same information written in the text box isn’t - is there of making it dynamic, or just relie on the orignal source?
Could you not just copy the dot symbol into format cells for positive values, and then use the same conditional formatting for both absolute charts? Still very cool, nevertheless.
Excelent explanations .
Glad you liked it, Vikram!
Great lesson!
Glad you liked it!
Another beautiful presentation.
Ur video clips are always clear and to the point. Another chart type to learn for my dashboards. Thank u from sunny Wigan 😎
Thanks so much, Martin!
Hey Myanda, you’re genius. Thank a lot for that trick really helpful 😁
Glad it was helpful!
Hi Mynda, really useful and clever tutorial which is clearly explained. Thank you. With regard to your source data you could consider copy and "paste as linked picture".
Thanks, Paul! Yes, absolutely use Linked Pictures if you prefer. I find they sometimes look a bit blurry, so I usually prefer to put my workings on another sheet.
Very nice, beautiful. Thank you Mynda!👏
Thank you! 😊
Hi Mynda,
This is Arup from India. Always getting new things in excel from you, thanks.
Glad to hear that!
Beautiful chart. Thank you for showing that and the conditional formatting.
Glad you liked it!
An easily overlooked strategy would be number formatting. That can change both the colour and the symbol; I let democrats code to 1, republicans to 2 and other seats 0. The prettiest results might be the scatter chart though. I enjoyed your solutions though and the array functions have the advantage of being dynamic.
Nice tip, Peter! Thanks for sharing.
We always learn new techniques .Thank you
Great to hear, Radwan :-)
I simply loved this... Thanks a lot!
Glad you enjoyed it, Arun!
No doubt it's excellent effort. Sure I need pretty long practice to make such by following you.
Thank you!
Well done, adding to my arsenal
Great to hear :-)
Yum, pies 🥧 I’m hungry
:-D me too!
Excellent tutorial Mynda! It is a very little used type of graphic, but I think it is very illustrative.
Glad you think so, Ivan!
I think this just might come in handy, thanks for sharing.
Great to hear!
Great work Mynda
Thank you!
great work. looking forward to your next video with percentage.
Coming soon!
Very good - how on earth do you know all these things!!😁
:-D Thanks, Mark!
Hi Mynda!Really Clever And Helpful Tutorial...Thank You :)
Thanks, Darryl!
Beautiful work. Thanks for the share.
Thank you, Syed!
Wonderful as usual. Thank you!
Cheers, George!
Nicely done Clear & clever :-) Thks
Thanks, Joseph!
Hey, could you please make a tutorial about Prezi
I'm not familiar with Prezi, sorry.
very clever as always. the groovy background music was something new ;-)
:-D keeping it fresh, Calvin!
Very cool Mynda!
Cheers, Chris!
Wow, great tutorial, thank you! High quality as always
Glad you liked it, James!
wow Mem Excellent video ,thanks for video
Thanks, Dipak!
Is there anything you can't do in Excel? Everytime I watch your videos my doubts grow stronger :-) BTW, thank you for your tip on fixing conditional format rules. Now they work fine and pasting as values have become my personal matra, too!
So pleased to hear you find my videos helpful, Jacek :-)
I made one just 2 days back :)
Next week I'll show you how to build a waffle chart using a stacked bar chart! Hopefully you'll find it useful.
Great stuff, although the chart is dynamic, the same information written in the text box isn’t - is there of making it dynamic, or just relie on the orignal source?
Thanks, Karon! You can link the text box to a cell that contains a dynamic label, but you can't colour code it like I did with this example.
It's 3:20 in the morning, and I am watching Excel videos. What is wrong with me. Great visualization idea!
Glad you enjoyed my video :-)
Nothing. I do that all the time watching videos from Mynda, Leila, Jon, Bill, Mike, Alan, and some others
I like the fast nature of the video expecting the viewer to man-up and be better...
Great to hear :-)
Why does the formula in cell B7 of the SEQUENCE Alternative Sheet =COLUMNS($A1:A$10)+10*(ROWS($A1:$A$10)-1) evaluate to 91 instead of 99?
Hi Joan, the numbering is from left to right, bottom to top. The top left cell is 91 and the top right cell is 100. It's supposed to be this way.
I ate waffles while watching ;)
Yum!
Could you not just copy the dot symbol into format cells for positive values, and then use the same conditional formatting for both absolute charts? Still very cool, nevertheless.
Yes, great idea, Rico!