ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Adding Gridlines to an XY Scatter Area Chart (https://www.excelbanter.com/charts-charting-excel/134663-adding-gridlines-xy-scatter-area-chart.html)

[email protected]

Adding Gridlines to an XY Scatter Area Chart
 
I followed Jon's example on an XY Scatter Area Chart --
http://peltiertech.com/Excel/Charts/XYAreaChart.html, which worked
beautifully, however I would also like the gridlines to come across
the area chart. Is there any way to do this besides drawing the lines
on the graph by hand?

Dustin


Jon Peltier

Adding Gridlines to an XY Scatter Area Chart
 
You've found that the area chart obscures the gridlines behind it. You can
add some dummy gridlines using error bars, following this procedu

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

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


wrote in message
s.com...
I followed Jon's example on an XY Scatter Area Chart --
http://peltiertech.com/Excel/Charts/XYAreaChart.html, which worked
beautifully, however I would also like the gridlines to come across
the area chart. Is there any way to do this besides drawing the lines
on the graph by hand?

Dustin





All times are GMT +1. The time now is 08:33 AM.

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