View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How to lock a line put on a graph in excell

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

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

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


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