Excel Dot Map Charts - Yes, this is Excel!
Oct 21, 2022 7:00 AM

Excel Dot Map Charts - Yes, this is Excel!

External YouTube Channel

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.

Creating a Dot Map Chart

  • Step 1: Find an image of a dot map and insert it in Excel (Insert tab > Pictures). I found one on pngwing.com and you can get a copy of it by downloading the workbook at the link above.
  • Step 2: use the tools on the Picture Format contextual tab to adjust the colour to suit your needs. I used the recolor tool. See the video for a demonstration.

Read the full article on myonlinetraininghub