Perfect! That is just what I needed rather than having to draw a line!

Thanks!

Jill


"Debra Dalgleish" wrote:

Jon Peltier has instructions for adding a horizontal line to a chart:

http://www.peltiertech.com/Excel/Cha...s.html#AddLine


Sillie_J wrote:
I would like to put a reference line in a graph. In other words, I have a
value and I would like to have a horizontal line that corresponds to this
value, with all other data points surrounding it. That way, viewers of the
graph can see how data points compare to this value. Is this possible in
Excel?

Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html