How can I color a region of an Excel graph?

[Guest]

I wish to color a region of an Excel graph between two, defined, straight
lines. The coloring should not obscure graph curves and points between the
straight lines. Is it possible?

 

[Jon Peltier]

Good straight line. Here are a couple techniques you could use:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=590
http://peltiertech.com/Excel/Charts/XYAreaChart2.html

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