The Olympic Medals by Country Chart – Improved now
My Olympic medals by country year visualization in excel is received well by readers. I got few interesting emails on it.
Robert from Germany shares an interesting approach at doing this, by doing a heat map of the medal counts on an outline world map. This is very impressive and involves flood filling countries with a shade of gray based on the medals they got. Download and play with it
Jon from PTS Blog shares a simple technique to color the chart by continent to add more context to it. He does that by creating various named ranges and manually adjusting the color based on the range. Read more on how to this. Download and play with his version.
Thanks to both of you, I have learned new tricks in charting. Enjoy 🙂
Introducing our Online Power BI Class:
Would you like to join me on a date with Power BI? In this comprehensive online class, learn all about Power BI so you can create beautiful, insightful & interactive reports. Join me and rest of the play mates for our first ever Power BI Play Date.Click here to know more and join us.
Leave a Reply
|Excel Links of Week – Who is Obama edition? [Aug 12]||Beyond If and Sum, 15 really useful excel formulas for everyone|