How to Create a DYNAMIC Map Chart With Drop-Down (works with ANY Excel version)
Jan 25, 2018 Excel Infographic Chart Templates
Create a simple but effective Excel Dynamic Map Chart with drop-down. Also Conditionally formats the largest values on the map for improved readability.
★ My Online Excel Courses ► https://www.xelplus.com/courses/
00:00 How to Create Interactive Map Charts in Excel
03:03 Adding Map Picture
06:12 Data Preparation
07:40 Setting Up the Chart
09:29 Adding Interactivity to the Chart
12:08 Updating the Bubble Chart
15:03 Conditionally Format Data Points
Learn how to create a simple but impressive dynamic map chart that enables you to visualize specific KPI's by geography. This method doesn't use the relatively new Bing map feature, so it is works on all Excel versions.
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
The technique shown uses a scatter plot first to set up the respective points on the map and then turns it into a bubble chart to be able to visualize the actual KPI.
I also show you how you can conditionally format specific data points to bring the attention to certain categories. In this case I conditionally format the largest data point in the chart in a different color than the rest. This technique is really simple but has a very powerful effect. It makes the difference between a "nice" Excel dashboard to a "great" Excel dashboard. All it takes is 3 minutes of your time.
⯆ Download the workbook here: https://www.xelplus.com/simple-excel-dynamic-map-chart-with-drop-down/
Links to related videos:
SumIFS formula: https://youtu.be/AZuBNWMh7VM
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
4:19
Bearing
14 hours agoAustralian Speech Is UNDER ATTACK! A Very Important Video.
1.1K15 -
22:44
Danny Haiphong
12 hours agoPepe Escobar: Putin & China Drop Middle East BOMBSHELL on Israel, Netanyahu FURIOUS
1.19K1 -
28:58
Science & Futurism with Isaac Arthur
22 hours ago $0.11 earnedIs Privacy Going Extinct?
5974 -
10:21
Degenerate Jay
14 hours agoStellar Blade's New DLC Looks Amazing! Photo Mode And NieR Crossover!
2511 -
2:02
LFA TV
16 hours agoWOMAN'S LIFE SAVED FROM DEADLY INFECTION!
3.1K1 -
2:27:43
Price of Reason
14 hours agoStallone DELIVERS Knock Out Punch with Tulsa King! Agatha All Along CRINGE! Ubisoft Stock TUMBLES!
26.7K2 -
LIVE
WeatherNation
2 days agoWeatherNation Live 24/7
5,480 watching -
1:32:14
Kim Iversen
12 hours agoDoctors IGNORED Her Horrifying Vaccine Injury. Hear Her Story Straight From Her | Alexis Lorenze
83.3K131 -
1:37:32
Glenn Greenwald
13 hours agoX Bans Reporter After JD Vance "Dossier" Published; Major DNC Fundraiser On Why She Is Leaving The Dem Party | SYSTEM UPDATE #342
122K162 -
7:51
Colion Noir
10 hours agoExposed, Kamala Harris Sponsored Handgun Ban & Confiscation Bill
56.5K33