G Guest Jan 3, 2006 #1 How do I highlight (e.g., bold) just 1 particular y-axis gridline? I want to make it stand out as a threshold.
How do I highlight (e.g., bold) just 1 particular y-axis gridline? I want to make it stand out as a threshold.
A Andy Pope Jan 3, 2006 #2 Hi, You can not format individual grid lines. You can add a dummy series to act like a grid line and format that as required. Jon Peltier has an explanation for creating arbitrary grid lines that you can adapt. http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html Or here are some explanations of adding lines to charts. 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
Hi, You can not format individual grid lines. You can add a dummy series to act like a grid line and format that as required. Jon Peltier has an explanation for creating arbitrary grid lines that you can adapt. http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html Or here are some explanations of adding lines to charts. 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
