How to create a worldwide map with Excel 2003

iil888

New Member
Joined
Aug 8, 2014
Messages
2
Hello,


I need to create a worldwide countries map using Excel 2003.



It must show all the countries in the world, and each country must have a different colour depending on the values of a tab.



Please, how can I do it?



Thanks
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
A map? As in a graphic / image of a world map? Maybe a different program would work better for that...

What does this mean: "depending on the values of a tab"
 
Upvote 0
Ztodd,

Thanks

Can you recommend me any free program?

"depending on the values of a tab" means countries with value bigger than 5, red colour, lower than 5, blue colour, depending on the figures on an spreadsheet.

Thanks
 
Upvote 0
I typed a reply and clicked the wrong button and it vanished. I hate poorly designed webpages that do that.

I don't know any offhand- you might have to learn a little coding...

Here's a thought, if you don't need a perfectly drawn map, you could resize rows and columns on a sheet in Excel to be real small, and change background color for some cells in the shape of a country. You could have a table on another sheet telling which cells on the map sheet correspond with which country. Some vba code can be used to change the colors by looking at the table that you mentioned.

You'd probly want to start with finding a good map image with good country borders drawn in it, which could somehow be used to create the excel map sheet. Not sure how, but it probably can be done.
 
Upvote 0

Forum statistics

Threads
1,226,453
Messages
6,191,134
Members
453,642
Latest member
jefals

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top