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.

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Marvin" wrote in message
...
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.