Problem with conditionally set chart colors

[ebutter]

V.10
XML data using ADO.NET driver

I have some chart where colors are conditionally set based on a formula.

For example:

Formula Value = All Cap Equity then Green
Formula Value = Cash and Equivalents then Red
etc.

User can dynamically affect Formula Value such that I can't set all possibilities.

Formula Value = Dynamic Input then ??

Everything works fine until one of these wildcard inputs happens, then things become unpredictable. Colors duplicate, colors that were set don't work, etc.

Anybody have any thoughts.

thanks! ebutter