Automatic repositioning data labels subset when chart updates

[Guest]

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

 

[Andy Pope]

Hi,

Can you use a second series to hold the data label positions

This example do last point and Min/Max but can be adapted to do
first/middle/last.
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy

 

[Guest]

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.

 

[Jon Peltier]

The way to accomplish this is to add an XY series to the chart which
contains only the points you want labeled. Make the points invisible (no
markers, no lines), and add data labels. Link the data labels to cells in
the worksheet which use formulas to construct the label you want displayed
at each point. Use one of these free Excel utilities to add labels to a
series using cells in the worksheet:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______