Formatting

D

Dan deGrassi

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating bolded text exclusively. 0
Make Y-axis values correspond to x- axis value 1
Why do I get some missing minor gridlines in an excel chart? 2
simple chart 0
Chart formatting problems (multiple) 4
Comparative Scatterplot?? 1
How can I highlight only one Y axis gridlines in an excel graph?. 3
Sorting and filtering text 0

Top