Excel Dot Map Charts - Yes, this is Excel!

Interactive dot map charts are not built into Excel, but with some creative use of Excel’s built in tools we can create something unique.

0:00 How to build dot map charts in Excel
0:20 Preparing the Chart Data
1:09 Dot Map Image
1:58 Scatter Chart
7:00 Custom Data Labels
9:53 Highlight Max Region
12:25 Interactive Slicer
13:59 Dynamically Updating the Chart
14:36 File Download Link

[IvanCortinas_ES]

A true artist, Mynda! Very bright graph presentation. Thank you!!!

[tmb]

This is cool, if a bit painstaking! Something I find useful is if you hold down Alt while you’re resizing or moving an image/chart/any other object, it’ll snap to the grid. Saved me ages obsessively trying to line stuff up.

[sachin.tandon]

A bit painstaking, but creatively done! You've probably identified the use-case of another type of graph too! Thx for sharing!

[ricos]

That's a fantastic example. Something I might never use, but good to know!

[lisarevelli]

This is great! Thank you! Data visualization like this is very cool!
I didn't Excel can has this capability!

[MsSilver]

Great Technique. Awesome presentation. Great Job. Always your video rocks ...

[lukev]

Amazing work… as always. Thank you for sharing!

[darrylmorgan]

Hi Mynda!Really Super Cool Chart...Thank You :)

[Valandor_Celestial_Warlock]

This is awesome. Definitely going to work on this one. Thank you!

[davetheman]

You never disappoint. Thank you for this lesson.

[josepaulomagalhaes]

You could build another version, using real map coordinates from each location, downloaded from internet, and them matching that with the dots in the graph. I think it will save a lot of time and also could be dinamic.

[davidferrick]

PowerBI to the rescue... couple of clicks and done. This is nice but the time to build would not work for me. Still very cool and gives me some ideas for other things.

[tariqdaas]

Useful and valuable information!! :)
Can I do this in Google Sheet?

[Cloversmom]

Great video, I have an idea for how I can use this in my job. How do we know what the coordinates for the scatter plot should be? Is there an actual calculation or are you just trying different combinations until the right dot lights up?

[smith]

Hi, I’m from UK :)
My company wants me to learn Power BI to convert our data into a easy format, pulling in our machine monitoring data, sales force data and many other sources into one database.
I’m looking at courses and see you offer one, however do your courses revolve around a data set you give out, or can the trainees use their own data.
Sorry if that’s a stupid question, it’s just I’ve watched so many videos on this and I struggle to link up how I can do the same thing with my own data when it’s not relatable to what I need to achieve.
Thanks for your time
Tom

[tsalb]

Out of interest I found that when setting shapes text to equal cell values, the text in the shape takes on the text formatting of the cell.

[arieldai]

Why do we use so many dots instead of just a big one to represent regions?

[anasz]

That's art 🎨 not Excel... amazing