two line bar graph
 

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?

two line bar graph
 

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?