Why Isn't My Map Working?!? 10 Excel Troubleshooting Tips

The most common issues and how to fix them.

Download the Excel File

https://depictdatastudio.ck.page/troubleshootingmapsinexcel

What's Inside

• 0:00 Intro
• 1:10 Dataviz On The Go
• 2:16 Making a new map - What didn't work
• 2:56 (1) Make sure you're on good internet
• 3:38 (2) Convert to Geography (or not)
• 5:20 (3) Make sure your headers are (correctly) labeled
• 6:02 (4) Convert to an Excel Table
• 6:45 (5) Spelling
• 7:13 (6) Leading or trailing spaces
• 7:54 (7) Special characters
• 8:19 (8) Add higher-level geographic details in a column(s) to the left 9:35 (9) Check alternative/former names
• 10:06 (10) Check language translations (e.g., both English and siSwati spellings)
• 10:30 Repeating the 10 troubleshooting tips
• 13:46 Your turn
• 14:13 Personal note from Ann