🗺️Create a DYNAMIC Map Chart in Excel – Data Validation, UNIQUE, SORT and FILTER☝️

Map Charts in Excel are a visually stunning way of representing geographical data. Using a map chart, we can see how values vary from state to state or country to country based on a shaded gradient fill.

Filled Map Charts are available in Microsoft Excel 2016 and later.

In this video, we need to create a map chart based on a dataset AND make it completely dynamic so that when we select a region from a drop-down list, the map chart updates.

We can achieve this result using a combination of Excel functions: UNIQUE, SORT and FILTER combined with a Data Validation drop-down list.

🔗LINKS to related videos:
📊Pimp my Excel Chart and Slicer: https://youtu.be/RbqFOOLTLuc
📈Excel What-If Analysis: Scenario Manager: https://youtu.be/oPHfhKpH3pc
⬇️Fill Down Dates in a Series EXCLUDING Weekends: https://youtu.be/fmExg9navdQ

🤝Let's CONNECT on social:
➡️TikTok: https://www.tiktok.com/@cellmates_
➡️Instagram: https://www.instagram.com/cellmatestr...
➡️LinkedIn: https://www.linkedin.com/in/deborahas...
➡️Twitter: https://twitter.com/CellMates_
➡️Facebook: https://www.facebook.com/CellMates/

#excel

Видео 🗺️Create a DYNAMIC Map Chart in Excel – Data Validation, UNIQUE, SORT and FILTER☝️ канала Cellmates