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
-
14:53
Winston Marshall
4 days agoTrump Just Said THIS On X...It Will Surprise You!
79.2K41 -
38:37
Patriots With Grit
7 hours agoRestoring Our Republic: Taking Back Our Border | Kim Yeater, Eddie Cornell & Scotty Saks
41.7K8 -
51:54
TheTapeLibrary
19 hours agoDisturbing Haunting of a Witches' Prison | The True Story of The Cage
35.9K4 -
0:30
steveinman
1 day agoBrotherly Love
61.3K4 -
2:58:53
Jewels Jones Live ®
1 day agoVIOLENT RHETORIC | A Political Rendezvous - Ep. 92
76.9K40 -
1:13:17
Exploring With Nug
16 hours agoMissing Person's Remains Found In Virginia Well
60.8K14 -
2:00:56
Tate Speech by Andrew Tate
14 hours agoEMERGENCY MEETING EPISODE 76 - GYAL DEM
294K480 -
23:06
MYLUNCHBREAK CHANNEL PAGE
1 day agoThe Old World is in The Catacombs? - Part 3
72.1K34 -
LIVE
Right Side Broadcasting Network
5 days agoLIVE REPLAY: Pres. Trump Holds a Rally in Wilmington, NC on Jobs, Inflation, & the Economy - 9/21/24
3,446 watching -
47:18
Vigilant News Network
1 day agoShocking Details Emerge About Trump’s Would-Be Assassin and “Wife” | The Morning Catch Up
88.8K55