Gridlines on Area/Stacked Area charts

[Guest]

I'm trying to see the gridlines on an Stacked Area chart. I understand that
transparency isn't supported, though visible and greyed out. Is there
another way to have above a series be red and below be green and show the
vertical and horizontal gridlines?

TIA

 

[Jon Peltier]

Add gridlines using this technique:

http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html

Since these gridlines are really error bars, they are drawn in front of
area chart series.

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