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

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.

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

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.
--
David Biddulph

"cambium" wrote in message
...
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.

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

Here are a couple examples:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.
--
David Biddulph

"cambium" wrote in message
...
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.