Custom gridline - one single gridline at a specific value
 

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.

Custom gridline - one single gridline at a specific value
 

Well, what I have ended up doing is to simply insert an "Autoshape" line,
after turning off the gridlines.
"Barry Guidry" wrote in message
...
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.

Custom gridline - one single gridline at a specific value
 

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" wrote in message
...
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.

Custom gridline - one single gridline at a specific value
 

Yes, that is it! Thanks very much
"Andy Pope" wrote in message
...
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" wrote in message
...
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.