Hi, so here's the thing. So far I have used VBA for coloring my bar charts based on value criteria. e.g. if bar is > 0.25 then green. Not I need to use the same thing based on the label name. E.g. if the label says "Troi" color bar green, if it says "Person 14", color bar red and if there is a "*" before a person e.g. "*Troi", then color bar yellow.

Anyone has any ideas or something on their mind? - Any info much appreciated!!!

Thanks a lot!