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!

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!

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!