I've seen several ways to do this, but the one I prefer is to add 3
additional series to the chart. For example.

Green = 1
0.9 <= Yellow < 1
Red < .9

For the green series, do this

=IF(A1=1,A1,NA())

Yellow: IF(AND(A1=.9,A1<1),A1,NA())
Red: IF(A1 < .9,A1,NA())

Then I add these three series to the chart and change the color of the
series but keep the shape the same.

I'm sure the Chart Experts have other ways, but this is one option.
--
HTH,
Barb Reinhardt




"DOUG ECKERT" wrote:

I want to instruct sections of the chart plot area to display red, yellow and
green bands based on stops, or thresholds. I have tried Format Plot
AreaGradient FillGradient Stops, but it was very imprecise and hard-to-use.

'Suggestions?

DOUG