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.