View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
DOUG ECKERT[_2_] DOUG ECKERT[_2_] is offline
external usenet poster
 
Posts: 66
Default RedYellowGreen Color Banding in Chart Plot Area

Jon: That got me a little bit closer. But, the color bands kept cancelling
each other out, i.e., red saved over yellow, yellow saved over green and so
on. The little chart symbol in the upper left-hand side of the page you sent
me is what I am trying to accomplish...

DOUG

"Jon Peltier" wrote:

Doug -

Try this:

http://peltiertech.com/Excel/ChartsH...orizBands.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DOUG ECKERT" wrote in message
...
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