Gulf Stream,

Set up two series €“ one for positive values and one for negative values.
Add a one-row space between any data point that crosses zero. For example,
assume your original data is in a single column starting in cell A2. The
data looks like this:

a 2
b 4
c -4
d -3
e 6
f -3
g 5
h 7

Rearrange it to look like this (the title "Positive" is in cell A2 - the
entire range now covers A1 to B13:

Positive Negative
a 2 0
b 4 0

c 0 -4
d 0 -3

e 6 0

f 0 -3

g 5 0
h 7 0

Note the row-space between any row where the values go from positive to
negative or negative to positive. Create the area chart based on the revised
setup.

----
Regards,
John Mansfield
http://www.pdbook.com



"Gulf Stream" wrote:

How can I vary the color in an area chart between positive and negative data
points. Using zero as the defining level, anything greater than zero have
one color and anything less than zero having a different color. Thank you
for your help.