Well, what I have ended up doing is to simply insert an "Autoshape" line,
after turning off the gridlines.
> Is there a way to have only one single gridline in the y-axis, at a
> specified value?
>
> All I can find is to turn off/on gridlines in the Chart Options.
>
> Running Excel 2002.
Hi,
Have a look at Jon's page,
http://peltiertech.com/Excel/Charts/AddLine.html
Cheers
Andy

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
> Is there a way to have only one single gridline in the y-axis, at a
> specified value?
>
> All I can find is to turn off/on gridlines in the Chart Options.
>
> Running Excel 2002.
Barry Guidry - 14 Sep 2007 19:04 GMT
Yes, that is it! Thanks very much
> Hi,
>
[quoted text clipped - 10 lines]
>>
>> Running Excel 2002.