Can I make different colour gridlines in a single chart in Excel?

G

Guest

One particular horizontal gridline in my Excel chart marks a significant
limit. This gridline should be highlighted.

The gridlines above and below this can remain black.
 
D

David Biddulph

The best bet is to introduce an extra series, with X values at (or beyond)
the min and max limits for your chart, and Y values at your particular
value.
 

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

2007 line chart, can't make some gridlines heavier than others 10
Gridlines on Column Chart 5
Move gridlines in a chart so that they are above the numbers 1
Custom gridline - one single gridline at a specific value 4
How do I highlight an individual chart guideline in EXCEL? 1
how do I change default chart settings in excel? 1
Why do I get some missing minor gridlines in an excel chart? 3
Edit colour of one gridline in a 3D chart 1

Top