conditional formatting within chart

  • Thread starter Thread starter JC
  • Start date Start date
J

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
 
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)
 
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)
 
Bob -

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

- Jon
 
Back
Top