You could also add the line as another series in the chart. This will force
the line to move properly if the axis scale changes:
http://peltiertech.com/Excel/Charts/AddLine.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Shoque" wrote in
message ...
Hi, I've drawn a dotted line across my scatter graph but whenever i move
the graphs the dotted line stays in its original place. is there a way
to make the line part of the graph so that it resizes and moves in
conjunction with the graph?
Thanks
--
Shoque
------------------------------------------------------------------------
Shoque's Profile:
http://www.excelforum.com/member.php...o&userid=36320
View this thread: http://www.excelforum.com/showthread...hreadid=564595