Reference line in graph

[Guest]

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]

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

http://www.peltiertech.com/Excel/Charts/ComboCharts.html#AddLine

 

[Guest]

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

Thanks!

Jill