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.

Download the Excel file here: https://www.myonlinetraininghub.com/e...

Custom Slicer formats: https://www.myonlinetraininghub.com/e...

XLOOKUP alternative with INDEX & MATCH: https://www.myonlinetraininghub.com/e...

FILTER Function alternative: https://www.myonlinetraininghub.com/e...

View my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn: LinkedIn: myndatreacy

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