Vary Color based on value
 

Is there a way in a bar chart to have a bar be a specific color if less than,
lets say "5" ? Instead of manually changing each bar that is less than a
specific number.

Vary Color based on value
 

Hi,

Create two additonal columns of formulas, suppose your original data is in
B2:B12, then in C2 enter the formula =IF(B2<=5,B2,0)
in cell D2 enter the formula =IF(B25,B2,0)
Copy these formulas down.
Plot these ranges instead of your original range. Format one series one
color the other another.


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Jennifer" wrote:

Is there a way in a bar chart to have a bar be a specific color if less than,
lets say "5" ? Instead of manually changing each bar that is less than a
specific number.

Vary Color based on value
 

I tried this for a scatter plot with 3 series, but I don't want the value 0
plotted. How can make sure that if the cell has a value of 0 it does not get
plotted? I'm using excel 2000.

thanks,
anita

"ShaneDevenshire" wrote:

Hi,

Create two additonal columns of formulas, suppose your original data is in
B2:B12, then in C2 enter the formula =IF(B2<=5,B2,0)
in cell D2 enter the formula =IF(B25,B2,0)
Copy these formulas down.
Plot these ranges instead of your original range. Format one series one
color the other another.


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Jennifer" wrote:

Is there a way in a bar chart to have a bar be a specific color if less than,
lets say "5" ? Instead of manually changing each bar that is less than a
specific number.

Vary Color based on value
 

Replace the zero in the formula by NA()
--
David Biddulph

"anita" wrote in message
...
I tried this for a scatter plot with 3 series, but I don't want the value 0
plotted. How can make sure that if the cell has a value of 0 it does not
get
plotted? I'm using excel 2000.

thanks,
anita

"ShaneDevenshire" wrote:

Hi,

Create two additonal columns of formulas, suppose your original data is
in
B2:B12, then in C2 enter the formula =IF(B2<=5,B2,0)
in cell D2 enter the formula =IF(B25,B2,0)
Copy these formulas down.
Plot these ranges instead of your original range. Format one series one
color the other another.


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Jennifer" wrote:

Is there a way in a bar chart to have a bar be a specific color if less
than,
lets say "5" ? Instead of manually changing each bar that is less than
a
specific number.