Remove the textbox, then add a data label to one of the endpoints of the
line series. The data label will move with the point.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"nick" wrote in message
...
i have a two line bar graph. one of the graphs is just a straight line
that
shows .1 below the avg, so it changes as diff data is entered. i need the
label to move with the line as the line moves up or down. the way i have
it
now is by just using the text box which doesnt move as the line moves. is
there some way to tie the label in with the line movement?