View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?