Multiple Colors on Area Charts

[SarahR.]

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

 

[Andy Pope]

Hi

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

Cheers
Andy

 

[SarahR.]

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

 

[Andy Pope]

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