Hi,

Depending on the complexity you may be able to use a conditional chart.
http://www.andypope.info/ngs/ng32.htm

Although the data layout technique will work in MSGraph it would not be
dynamic unless you used some VBA code.

Cheers
Andy

Brian Reilly, MS MVP wrote:
I'm about to do this on a project where I want consistent colors by
"Brand Name" and I plan to use a VBA routine and a Select Case
statement on the "Brand Name" text and then apply the correct color
index. You just have to iterate throught the datapoints.

Brian Reilly, PowerPoint MVP

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info