How to lock a line put on a graph in excell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis - 11 Aug 2006 08:49 GMT

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.

Reply to this Message

Jon Peltier - 11 Aug 2006 13:33 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

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

Reply to this Message