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

G

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!
 
G

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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change line chart color based on condition like + and -. 1
Conditional formatting in a bar chart 4
Inverse colors in bar chart 1
plot > 0 as green and < 0 as red 4
Excel 07 - Stacked Chart Labels on Negative Values 1
Color gradient problem on X-Y chart 2
Two-tone color column chart 2
Graph Negative Values as Positive Values 0

Top