Dynamic Chart

[Karthik-Excelsior]

Hi Excel gurus,

I've 3 tables with data like the one shown on this trix https://docs.google.com/spreadsheet/ccc?key=0Ao7RzFobcTErdF81bHBaUlkxQi1VN2oyZ0VENXhkX1E&pli=1#gid=0

I would like to insert a bar graph (clustered column graph) that shows NA, CE & JPAC entries clustered together. The challenge now is, these clusters should be colored differently, i.e., NA entries in Orange, CE in Green & JPAC in Purple.

How do I do that? If you've figured it out, can you email me at karthigeyans87@gmail.com with your file.

Thanks in anticipation!

Karthik

 

[Robert Mika]

Does this help:
http://datapigtechnologies.com/blog...rt-series-colors-to-match-source-cell-colors/