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 🙂
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Excel Links of Week – Who is Obama edition? [Aug 12]||Beyond If and Sum, 15 really useful excel formulas for everyone »|