I would like to know if it is possible to have two different colors in the
plotted area of an area chart. In the end, I would like to have the color
for numbers less than 0 be one color and greater than 0 be second color.
Thanks

Hi

Have a look at Jon's page on horizontal bands.
http://peltiertech.com/Excel/ChartsH...orizBands.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SarahR." wrote in message
...
I would like to know if it is possible to have two different colors in the
plotted area of an area chart. In the end, I would like to have the color
for numbers less than 0 be one color and greater than 0 be second color.
Thanks

More specifically, is there a way to only change the color in the shaded area
of an area chart within specific ranges? The line on the graph rolls above
and below zero and I want the colors above and below zero to be differnt
colors. I know I can create two differnt series and plot the data as
different colors however, if there is a way to make the chart using one
series I would like to do that.
Thanks!
Sarah


"SarahR." wrote:

I would like to know if it is possible to have two different colors in the
plotted area of an area chart. In the end, I would like to have the color
for numbers less than 0 be one color and greater than 0 be second color.
Thanks

If I understand you then I think the answer is no.

You can not colour an individual point in an area chart.
You would need to use multiple series. But even with multiple series the
transition between points may not be as expected.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SarahR." wrote in message
...
More specifically, is there a way to only change the color in the shaded
area
of an area chart within specific ranges? The line on the graph rolls
above
and below zero and I want the colors above and below zero to be differnt
colors. I know I can create two differnt series and plot the data as
different colors however, if there is a way to make the chart using one
series I would like to do that.
Thanks!
Sarah


"SarahR." wrote:

I would like to know if it is possible to have two different colors in
the
plotted area of an area chart. In the end, I would like to have the
color
for numbers less than 0 be one color and greater than 0 be second color.
Thanks