I want to show various geographical regions in a filled map, but my regions are a combination of States and Cities. For example, the Midwest region is MI, IN, OH, KN, WV, TN, and St. Louis MO. The Mid Atlantic is PA-except for Harrisburg and Allentown, DE, DC, and MD. The Greater NJ is NJ, and Allentown/Harrisburg, PA.
I want each of these regions to be filled with a different color.
Any idea how I would build this?
Audrey, this is going to take a bit of fancy foot work. It would be helpful if you could post a packaged workbook of at least the geographies you are interested in, put in a bit of dummy data for each one if need be, nothing fancy. I'll take a look at it in the morning.