Formatting a single grid line

[Reney Langlois]

Don't laugh but I was wondering if there was a back door
way of bolding up a single horizontal gridline to make it
stand out from the rest. My alternative is to draw a line
on the chart but then I need to adjust it if my scale
changes.

Thanks much,

Reney

 

[Andy Pope]

Hi Reney,

Unfortunately you can only format all of the gridlines at once.

Have a look at these examples for adding a line to a chart.

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts/straight_lines/index.html
http://www.andypope.info/charts/averageline.htm

Cheers
Andy