View Full Version : Thematic Map

10-11-2012, 07:10 PM

I have a map of North America that shows current data by coloring the states based on a number range, some basic excel calculations and a few lines of VB, really do not know much about VB....what I would like to do is have the ability to scroll through columns of data, so each time you scroll the color of the states change.....I can send you the file if needed

Any help greatly appreciated


Simon Lloyd
10-11-2012, 08:31 PM
Just attach your file here, go to "Go Advanced", scroll down "Manage attachments" and attach your file, we'll see what we can do :)

10-12-2012, 03:36 PM
Here you go and thanks

Bob Phillips
10-12-2012, 04:51 PM
Try this

10-12-2012, 05:27 PM
This is great..Thanks..would there be away to remove the button and have the map change based on the list selection?

Thanks again

10-12-2012, 06:12 PM
I did manage to have the map change based on the selection from the list you inserted, I moved the logic to another tab which I can hide but can not get the list to work now, its as if its tied to the original cells??

Bob Phillips
10-13-2012, 12:49 AM
Here you are

10-13-2012, 06:06 AM
Thanks to everyone for your help, first time I have used this forum....so I have one last question, if I wanted an option to have this to auto scroll through the months, is that a big deal to accomplish?

Thank again

Bob Phillips
10-13-2012, 01:49 PM
Depends upon what you mean by scroll through the months.