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: [ Ссылка ]
📈Excel What-If Analysis: Scenario Manager: [ Ссылка ]
⬇️Fill Down Dates in a Series EXCLUDING Weekends: [ Ссылка ]
🤝Let's CONNECT on social:
➡️TikTok: [ Ссылка ]_
➡️Instagram: [ Ссылка ]...
➡️LinkedIn: [ Ссылка ]...
➡️Twitter: [ Ссылка ]_
➡️Facebook: [ Ссылка ]
#excel
![](https://i.ytimg.com/vi/2N41rda0ddU/maxresdefault.jpg)