ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Grid Lines on an Area Chart (https://www.excelbanter.com/charts-charting-excel/46466-grid-lines-area-chart.html)

Phil Hageman

Grid Lines on an Area Chart
 
Is there a way to get horizontal (Y axis) grid lines to pring across an area
chart?

Jon Peltier

You want them in front of the series? Use one of these techniques, which
use alternative chart elements which display in front of area chart series:

http://peltiertech.com/Excel/Charts/...Gridlines.html
http://peltiertech.com/Excel/Charts/AddLine.html

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


Phil Hageman wrote:

Is there a way to get horizontal (Y axis) grid lines to pring across an area
chart?



All times are GMT +1. The time now is 10:42 PM.

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