separate colors for positive and negative bars in bar charts?

When using the "invert if negative" function in an excel chart, is it
possible to set a default color for negative numbers (i.e. positive bars will
be Blue and negativ Red)? I know you can change the colors individually, but
have not found a way to make it dynamic. This gets tedious when updating
weekly charts.

Hi,

Here is an explanation of how to get this feature working.
http://www.andypope.info/charts/Invertneg.htm

Cheers
Andy

t killion wrote:
> When using the "invert if negative" function in an excel chart, is it
> possible to set a default color for negative numbers (i.e. positive bars will
> be Blue and negativ Red)? I know you can change the colors individually, but
> have not found a way to make it dynamic. This gets tedious when updating
> weekly charts.

--

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