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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
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:
Upvote 0

Forum statistics

Threads
1,214,262
Messages
6,118,549
Members
448,835
Latest member
Profast123

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