View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default zones in excel charts

Here are a few ways to set up colored regions in a chart:

http://peltiertech.com/Excel/Charts/...ackground.html
http://peltiertech.com/Excel/Charts/...ticalBand.html
http://pubs.logicalexpressions.com/P...cle.asp?ID=508

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

"bkrim" wrote in message
...
I'd like to be able to set up zones in an Excel chart. Imagine a bell
curve.
Areas under the curve within one standard deviation could be green, those
between one and two standard deviations would be yellow, and those more
than
two would be red. Or I can have an X - Y scatter chart. If the X-axis
runs
from 0 - 10, I might want 0 - 3 as red, 3 - 5 as green, and 5 - 10 blue.
Just as an example.