conditional formatting within chart
 

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

conditional formatting within chart
 

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(H10,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)



"JC" wrote in message
...
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

conditional formatting within chart
 

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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob Phillips" wrote in message
...
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(H10,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)



"JC" wrote in message
...
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

conditional formatting within chart
 

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" wrote in message
...
Here's a tutorial that expands upon the technique Bob describes:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob Phillips" wrote in message
...
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(H10,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)



"JC" wrote in message
...
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

conditional formatting within chart
 

Bob -

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob Phillips" wrote in message
...
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" wrote in message
...
Here's a tutorial that expands upon the technique Bob describes:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob Phillips" wrote in message
...
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(H10,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)



"JC" wrote in message
...
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