Line and text box move by themselves

[David Brown]

(Excel 2000)

I regularly add horizontal lines and text boxes to charts, using the Draw
tool.

When I return to the charts some time later I find that both the line and
the box have "slipped" lower down the chart. They can even end up below the
x-axis.

This happens all the time on some charts. but on others the line and text
box appear properly fixed. So far as I am aware I am not doing anything
different with them.

Is there a cure for this or is it a program defect? Any assistance
gratefully received.

[Jon Peltier]

If you use data series for lines and labels, they will remain anchored
in place:

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

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


David Brown wrote:

> (Excel 2000)
>
> I regularly add horizontal lines and text boxes to charts, using the Draw
> tool.
>
> When I return to the charts some time later I find that both the line and
> the box have "slipped" lower down the chart. They can even end up below the
> x-axis.
>
> This happens all the time on some charts. but on others the line and text
> box appear properly fixed. So far as I am aware I am not doing anything
> different with them.
>
> Is there a cure for this or is it a program defect? Any assistance
> gratefully received.