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: • 📊Pimp my Excel Chart a...
📈Excel What-If Analysis: Scenario Manager: • Excel What-If Analysis...
⬇️Fill Down Dates in a Series EXCLUDING Weekends: • ⬇️Fill Down a Series o...
🤝Let's CONNECT on social:
➡️TikTok: / cellmates_
➡️Instagram: / cellmatestr. .
➡️LinkedIn: / deborahas. .
➡️Twitter: / cellmates_
➡️Facebook: / cellmates
#excel
2 окт 2024