conditional formatting within chart

[JC]

I've got a bar chart (the lines flow left to right) that i update every
week...the current bar chart i'm using has some sort of conditional
formatting where if the number is >0, the bars are all green, but if the
number is <0, then all the bars are red...for some reason my original chart's
formatting stopped working. how do i set that up, short of highlighting each
bar...i've got about 20 graphs to update...

Thanks!!!
JC

 

[Bob Phillips]

The way that I would do it is to have two sets of helper columns, one with
the negatives and one with the positives, like so

=(IF(H1<0,ABS(H1),NA())

and

=IF(H1>0,H1,NA())

and copy down. Then chart those two sets of data in one go. The bars will be
setup as different colours and you can format to red and green.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Jon Peltier]

Here's a tutorial that expands upon the technique Bob describes:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

- Jon

 

[Bob Phillips]

Sheesh! And there was me thinking I thought it up !

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Jon Peltier]

Bob -

I didn't think of it either, but I sure don't remember who I copped it from.

- Jon