Custom gridline - one single gridline at a specific value

  • Thread starter Thread starter Barry Guidry
  • Start date Start date
B

Barry Guidry

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.
 
Well, what I have ended up doing is to simply insert an "Autoshape" line,
after turning off the gridlines.
 
Andy Pope said:
Hi,

Have a look at Jon's page,
http://peltiertech.com/Excel/Charts/AddLine.html

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Barry Guidry" <[email protected]> wrote in message
news:%[email protected]...
> 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.
>
Click to expand...


I am really thankful to you. Your advice in form of this link worked 100% accurately... thank you very much...
 
Back
Top