Hi,

Did you ever figure out how to do this. I have a similar situation where I
have 2 years on a chart and each month, I add a month. I would like the
oldest month to disappear and the new month to appear on the chart. Is there
a way to achieve this automatically?

Thanks for you help.

"igottaknow" wrote:

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