How to lock a line put on a graph in excell

[Guest]

I am trying to attach a line to a graph with months on the X axis. When I
add additional months I want the line to stay in between the original months,
however, it always moves as the graph expands.

 

[Jon Peltier]

Drawing objects cannot be linked to specific values of chart axes, unless
you incorporate them as series in the chart. Try the techniques here:

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

- Jon