charting, adding a random gridline

  • Thread starter Thread starter cate
  • Start date Start date
C

cate

I have fished thru the objects, looked at my macros, and I cannot
figure out how to add a random gridline on a chart. Is it as
convoluted as some postings seem to make this, or is there a method
I'm overlooking the obvious, some very simple... chart.gridline(axis,
val)?

Thank you
 
Excel's gridlines are associated with the axes they cross, with spacing
equal to the major or minor spacings of these axes. You can't add just
one arbitrarily located gridline.

You can add reference lines to a chart:

Add a Line to a Column or Line Charthttp://peltiertech.com/Excel/Charts/AddLine.html

Arbitrary Gridlines and Axis Labelshttp://peltiertech.com/Excel/Charts/ArbGridLabel.html

- Jon

Thank you very muck
 
Back
Top