Formatting an Image

[dacoffee]

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.

 

[GlennUK]

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

 

[GlennUK]

Re: Excel Tutorials

Excel Tutorials
I am really interested in learning as much as possible before I get back to work

Are you just posting an advertisement?