conditional formatting within chart


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
 
Ad

Advertisements

B

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

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

Advertisements

J

Jon Peltier

Bob -

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

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top