View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
igottaknow igottaknow is offline
external usenet poster
 
Posts: 1
Default Automatic repositioning data labels subset when chart updates

Several Excel charts. 25-month period. Each month a data point. Only 1st,
middle and last data points labeled. As data is updated each month, the data
labels do not shift up/down with the new first, middle, last data points.
Manual repositioning is time consuming.

Can the data labels be made to automatically shift with the chart line? If
so, can they also be forced to remain within the plot area?

I'm using Excel 2002 (10.5815.4219) SP-2