| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change the color in a chart, so POSITIVE values is e.g. GREEN and
How can I change the color in a chart, so POSITIVE values is e.g. GREEN and
NEGATIVE VALUES is e.g. RED. This in the same chart? Thanks! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change the color in a chart, so POSITIVE values is e.g. GREEN and
Hi,
For column/bar where the Invert if negative option is available see these pages for information. http://www.andypope.info/charts/Invertneg.htm http://peltiertech.com/Excel/ChartsH...fNegative.html For line chart http://www.andypope.info/charts/conditionalline.htm For xy scatter or line with markers only you can use 2 series based on the original data. Where 1 series plots only positive values and the other only negative. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MIKE-DENMARK" wrote in message ... How can I change the color in a chart, so POSITIVE values is e.g. GREEN and NEGATIVE VALUES is e.g. RED. This in the same chart? Thanks! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change the color in a chart, so POSITIVE values is e.g. GREEN
Thanks! It works!
"Andy Pope" skrev: Hi, For column/bar where the Invert if negative option is available see these pages for information. http://www.andypope.info/charts/Invertneg.htm http://peltiertech.com/Excel/ChartsH...fNegative.html For line chart http://www.andypope.info/charts/conditionalline.htm For xy scatter or line with markers only you can use 2 series based on the original data. Where 1 series plots only positive values and the other only negative. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MIKE-DENMARK" wrote in message ... How can I change the color in a chart, so POSITIVE values is e.g. GREEN and NEGATIVE VALUES is e.g. RED. This in the same chart? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change cell color to red & then green when value change in 2 cel | Excel Discussion (Misc queries) | |||
| Change a cell color based on a certain value (green or red) | Excel Worksheet Functions | |||
| can macros change cell color daily, i.e. green to red everyday? | Excel Worksheet Functions | |||
| I want the bar chart with customer selected colors, green color f. | 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
