ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Gridlines on Area/Stacked Area charts (https://www.excelbanter.com/charts-charting-excel/38999-gridlines-area-stacked-area-charts.html)

AgileDarrell

Gridlines on Area/Stacked Area charts
 
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/...Gridlines.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/
_______


AgileDarrell wrote:

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



All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com