| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
| Can I vary the shade or intensity of the color patterns? | Excel Discussion (Misc queries) | |||
| Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
| How can I vary graph color by range value | Charts and Charting in Excel | |||
| How to vary color in an area chart between negative or positive d. | Charts and Charting in Excel | |||
Linear Mode
