PDA

View Full Version : Thematic Map



leveyc
10-11-2012, 07:10 PM
Hi

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

Charlie

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 :)

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

xld
10-12-2012, 04:51 PM
Try this

leveyc
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

leveyc
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??

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

leveyc
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

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