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: [ Ссылка ]

Custom Slicer formats: [ Ссылка ]

XLOOKUP alternative with INDEX & MATCH: [ Ссылка ]

FILTER Function alternative: [ Ссылка ]

View my comprehensive courses: [ Ссылка ]

Connect with me on LinkedIn: [ Ссылка ]

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

свернуть