Most excellent! Thanks for your assistance.
I wasn't about to delve into VBA code, which I have found to be mind-numbing
in the past.
-BB.
"Andy Pope" wrote:
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