How can I highlight only one Y axis gridlines in an excel graph?.

[Walter]

How can I highlight only one Y axis gridlines in an excel graph?... I want
to show one y-axis gridline as more important than the others - a threshold
of sorts.

 

[Andy Pope]

Hi Walter,

The format applies to all gridlines. Easiest alternative is to create
your own. Here are a couple of examples for addline lines to charts.

http://peltiertech.com/Excel/Charts/AddLine.html
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

 

[Walter]

How can I highlight only one Y axis gridlines in an excel graph?... I want
to show one y-axis gridline as more important than the others - a threshold
of sorts.

Thank you Andy - exactly what I wanted.

 

[Walter]

Hi Walter,

The format applies to all gridlines. Easiest alternative is to create
your own. Here are a couple of examples for addline lines to charts.

http://peltiertech.com/Excel/Charts/AddLine.html
http://www.andypope.info/charts/averageline.htm

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Thank you - exactly what I wanted!