Annotate a point on a chart
 

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.

Annotate a point on a chart
 

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.

Annotate a point on a chart
 

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


"Marvin" wrote in message
...
Thank you, but that clearly does not meet my objective.

"Jon Peltier" wrote:

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.