Easy Excel Waffle Charts..Better than Pies and Doughnuts! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 6
Peter
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.
reply
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.
reply
Jacek
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!
reply
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!
reply
Rico
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.
reply
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.
reply
Paul
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-.
reply
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-.
reply
Karon
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?
reply
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?
reply
Martin
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 -
reply
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 -
reply
Add a review, comment
Other channel videos
