Create, for a chart data point or series, a dynamic self-adjusting data label linked to a worksheet cell
If you have only a few data points, use the technique used for the dynamic chart title -- it also works for a data label. If you have many points, consider a programmatic solution such as Rob Bovey's free Chart Labeler program.
