Annotate a point on a chart

[Guest]

Is there any way to annotate a point on a chart, and then have that
annotation always move with the point without further interaction?

As an example, I would like to add a note to a data point for November 2006.
My data spans the last 12 months. Each month, I delete the first point in
the series, and add a new point at the end.

Thanks.

 

[Jon Peltier]

You could use a data label, except the data label is linked to a point with
a given index. In other words, if you added a data label to November, the
11th point, if you then delete January, November becomes the 10th point, and
the label stays with the 11th point.

- Jon

 

[Guest]

Thank you, but that clearly does not meet my objective.

 

[Jon Peltier]

A more complicated approach would use a static range as the data label
source range. You would use a lookup table that had the date and desired
label, and in the data label source range, you would use a lookup using the
date corresponding to the cell in the data label range to find the
corresponding label in the lookup table.

- Jon