color coded USA map in Excel?

**yankstaster** · 05-26-2009, 04:35 PM

I have windows XP and I need to upload a map of the USA, and then color code each state based on a list of states and their corresponding revenue. Any thoughts? Thanks for the help.

**shg** · 05-26-2009, 04:47 PM

I've had this forever ..

**yankstaster** · 05-26-2009, 05:04 PM

Thanks, is it possible to have the state's color themselves under some sort of conditional formatting?

**shg** · 05-26-2009, 05:55 PM

No. You can do it manually, or write code to do it.

**Andy Pope** · 05-27-2009, 05:32 AM

Coded solution
http://www.andypope.info/ngs/ng12.htm

**yankstaster** · 05-27-2009, 11:14 AM

THANK YOU!!!

you rock.

**Audrey** · 01-05-2011, 05:33 AM

shg,

The US map is brilliant. Could you supply any other countries like Mexico or Malaysia??

I am looking forward to your reply. Thank you.

**rpetersen** · 04-10-2011, 03:52 PM

this sheet looks great, but how do it get the edit the macros and change the color of the states?

**teylyn** · 04-10-2011, 05:13 PM

rpetersen,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.