This week’s YouTube video was inspired by a question during one of my recent Dashboards in Excel courses.
The attendee wanted to build a map-based tracker to show which countries were on-track or ahead or behind. I haven’t yet managed to have a conversation with that person to understand their requirements in more detail so this video is just an example. It might be just what they want or it might be a million miles away. But hopefully it will provide them and anyone else who watches this video, with the foundation to create their own map-based tracker.
To build the tracker I’ve used a Filled Map Chart, which was added to Excel in 2016, together with these formulas:
=(B3/12) * $B$13
=IF(D3>=C3,1,0)
=IF(D3>C3,1,IF(D3=C3,0.5,0))
You can download a copy of the sample file by clicking through to YouTube. The link is in the YouTube description.