View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
NG NG is offline
external usenet poster
 
Posts: 18
Default how do I fix the data label to one data point?

I have to show on my chart some high and low points with the help of data
labels. So I set up some data labels on my chart. however my chart gets each
day one new point and as the line of my chart moves the data labels which I
set up moves to the next day. How can I fix it to the initial data point
which I chose (which is a high or low point)? And is it also possible to draw
lines to the axes from one data point I chose? Because chart is a small one
it is difficult to notice to which point the label is connected. I use Excel
2003. Is it easier on Excel 2007? Thanks a lot.