Formatting an Image

dacoffee

New Member
Joined
Mar 14, 2011
Messages
1
Hi,

I am not an Excel expert so please pardon me if this question sounds stupid.

I have two column on Excel. Country and Revenue. Now, I want to create some kind of Macro which can populate an image based upon the data. For example, consider two columns:

Country | Revenue

US | $20,000
Australia | $40,000

There is an image - World Map. Now, when I run the macro, it should display (or highlight) the figures $20,000 and $40,000 at US and Australia on that World Map. The image can reside on the same sheet or different sheet. I actually wanted to have this image come up on running the Macro.

So, basically, I am trying to have a Map show data/pattern which makes it easier for User to identify/read data.

I am sure we may have other tools to implement this but can i get any closer on Excel? I am not sure how much can Excel deliver for such functionalities.
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Excel used to have this functionality, but not any more, not without shelling out some money on an add-in ( MapPoint is supposed to do this, but I've never been bothered enough to buy it ).

http://www.mrexcel.com/tip100.shtml
 
Last edited:

Forum statistics

Threads
1,141,138
Messages
5,704,497
Members
421,353
Latest member
jekoxien15

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
Top