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.
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.
