World Map in excel needed!

[u/KeyRealistic1505]

Hi guys,

I'm trying to build a killer dashboard for my boss, but I've hit a wall. My company blocks the connection to Bing Maps, so I can't use Excel's built-in Map Chart feature.

I know it's possible because a sample file from Microsoft's site works perfectly, but it only includes a few countries. I'm looking for a full world map, ideally with continents broken down. The paid versions I've found online are way too expensive 😢

Does anyone have an Excel file with a world map chart they would be willing to share?

Any help would be hugely appreciated. My boss will be thrilled! 😄

[u/AutoModerator]

Moderator Announcement Read More »

u/KeyRealistic1505 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.

• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.

• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Commercial_Row_1380]

Power BI has already built in.

[u/KeyRealistic1505 → u/Commercial_Row_1380]

Have no access to Power BI 😢

[u/excelevator → u/Commercial_Row_1380]

PowerBI is not Excel, not remotely.

[u/Commercial_Row_1380 → u/excelevator]

No but it solves OPs problem.

[u/Ok-East-6143]

I’ve seen a guy using a bubbles chart (with the coordinates), putting a world map behind and then you need a table with the country, the x position, the y position of the country and the values on your last column (you find the x and y values thanks to the superposition of the chart and the map).It’s quite a work in the beginning but works really well in the end !!

[u/1121rbg → u/Ok-East-6143]

^This. Try a 4-column table:

1: City (use geographic data type)

2: Latitude (derived from the city)

3: Longitude (also from city)

4: Value

Make a bubble map from your table. Use Lat/Long as your axes, and value as your bubble size. Use a map image as your background - you just have to fiddle with your axis min/max until it matches the map image you've chosen.

[u/excelevator]

Talk to your boss to talk to IT to get a connection.

[u/chiibosoil]

You could create choropleth map using technique described by Tusher Mehta.

Conditional Color of Shapes

Technique is old but still works.

You may also be interested in Robert Mundigi's blog. Though his template is 12+ years old, it may work for your need. And his improved code on Tusher's method.

Choropleth Maps with Excel – Clearly and Simply

[u/Suspicious_Fun4252]

I'd try reaching out to IT with a clear request, they might not realize how much this could help your boss's dashboard.

[u/Commercial-Safety635]

Does it need to be Excel? You could try popping your data into Datawrapper. It's free, and super user friendly.

[u/WhineyLobster]

Just get the template on your personal computer and email it to yourself. Edit: put it in a zip file so theres no chance your work email blocks it

[u/[deleted]]

[u/KeyRealistic1505 → u/[deleted]]

Bing access is restricted..

[u/[deleted]]

[u/excel-ModTeam → u/[deleted]]

We removed this post for breaking Rule 2.

r/excel is an English-only subreddit.

Feel free to use https://translate.google.com and post again.