are there conditional formats on charts ?(differant culomn color)

[alon]

is there option to set conditional formats on charts ?
like change the color of a column with certain value

 

[Richard Flame]

Hello,

I have done this in the past by writing a macro...Excel assigns random
colors to charts, so sometimes by changing your data the color of
certain columns changes. i could not find the online reference i used
but try to find/write the macro to do that.
Hope this will help (i'll look for the code and i'll reply back if
found)

 

[Richard Flame]

http://exceltips.vitalnews.com/Pages/T0111_Positive_and_Negative_Colors_in_a_Chart.html

This might give u an idea

 

[HEK]

Hmm, not sure you need a macro. Hv a look at Andy Pope's excellent pages for
instance:
http://www.andypope.info/charts/Invertneg.htm

GL,
Henk