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 Chart
http://peltiertech.com/Excel/Charts/AddLine.html

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



cate wrote:
> 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

On Dec 6, 2:47*pm, Jon Peltier <jo...@SPAMpeltiertech.com> wrote:
> 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
> -------
> Jon Peltier
> Peltier Technical Services, Inc.http://peltiertech.com/
>
> cate wrote:
> > 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

Thank you very muck

On Dec 8, 8:03*pm, cate <catebekens...@yahoo.com> wrote:
> On Dec 6, 2:47*pm, Jon Peltier <jo...@SPAMpeltiertech.com> wrote:
>
>
>
> > 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
> > -------
> > Jon Peltier
> > Peltier Technical Services, Inc.http://peltiertech.com/
>
> > cate wrote:
> > > 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
>
> Thank you very muck

oops, that typo doesn't look very nice ... much

That's okay, I got a chuckle out of it.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



cate wrote:
> On Dec 8, 8:03 pm, cate <catebekens...@yahoo.com> wrote:
>> On Dec 6, 2:47 pm, Jon Peltier <jo...@SPAMpeltiertech.com> wrote:
>>
>>
>>
>>> 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
>>> -------
>>> Jon Peltier
>>> Peltier Technical Services, Inc.http://peltiertech.com/
>>> cate wrote:
>>>> 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
>> Thank you very muck
>
> oops, that typo doesn't look very nice ... much