Change the color in a chart, so POSITIVE values is e.g. GREEN and

[Guest]

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!

 

[Andy Pope]

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/ChartsHowTo/InvertIfNegative.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

 

[Guest]

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/ChartsHowTo/InvertIfNegative.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