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.
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?
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!
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.
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!
Great work Mynda
Thank you!
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.
Beautiful chart. Thank you for showing that and the conditional formatting.
Glad you liked it!
Very nice, beautiful. Thank you Mynda!👏
Thank you! 😊
We always learn new techniques .Thank you
Great to hear, Radwan :-)
Hey Myanda, you’re genius. Thank a lot for that trick really helpful 😁
Glad it was helpful!
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!
Hi Mynda,
This is Arup from India. Always getting new things in excel from you, thanks.
Glad to hear that!
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!
Well done, adding to my arsenal
Great to hear :-)
Hi Mynda!Really Clever And Helpful Tutorial...Thank You :)
Thanks, Darryl!
great work. looking forward to your next video with percentage.
Coming soon!
Great lesson!
Glad you liked it!
Wonderful as usual. Thank you!
Cheers, George!
Beautiful work. Thanks for the share.
Thank you, Syed!
Excelent explanations .
Glad you liked it, Vikram!
Very cool Mynda!
Cheers, Chris!
Nicely done Clear & clever :-) Thks
Thanks, Joseph!
Wow, great tutorial, thank you! High quality as always
Glad you liked it, James!
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.
very clever as always. the groovy background music was something new ;-)
:-D keeping it fresh, Calvin!
Very good - how on earth do you know all these things!!😁
:-D Thanks, Mark!
wow Mem Excellent video ,thanks for video
Thanks, Dipak!
Yum, pies 🥧 I’m hungry
:-D me 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?
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.
Hey, could you please make a tutorial about Prezi
I'm not familiar with Prezi, sorry.
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 :-)
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 :-)
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 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.
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!