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 🙂
3 Responses to “Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)”
Thanks Chandoo, some great helpful tips here. I'm quite good at Excel (mainly thanks to you!) but I'm always learning. I love the link you gave above to Dynamic Arrays & Spill Ranges, I understand them a bit more now, and can see some uses for them.
I am glad you enjoyed the show Dermot.
Great to see you back! Enjoyed when you first started the podcast and super excited to start listening to you again!