Getting values to show colors in chart

  • Thread starter Thread starter machiel
  • Start date Start date
M

machiel

Hi,

Excel has numerous charting options. However, I need to display a ma
of a country and let certain parts change color according to value
that are stored in a database.

I can get the values in a normal graph but is it at all possible t
make a custom chart (like a map) where I can get certain parts t
correspond with the values?

Thanks
 
I don't believe you can do what you want without programming support. Suppose you create a map of, say the U.S. Now, create a freeform shape that aligns with the boundary of each state. Finally, use a event procedure (either a _Change or a _Calculate event) to monitor the values that are associated with the color of the various shapes.
 
Back
Top