Adding comments to series and fixing it to a point

[Guest]

I have a chart thats shows the evolution of a process and a new point is
added every week. I add comments (in a text box and an arrow that points to a
determined point). I was wondering if there is a way of fixing the arrow
(plus the comment, grouping) to a determined point so the comment and the
arrow "moves" with the graph as it evolves.

Thanks in advance,
from Argentina,
Nacho

 

[Jon Peltier]

Nacho -

You can use data labels to attach text to a point. Rob Bovey has a free add-in which
helps you add text from any range to a series of points, at http://appspro.com. The
arrows aren't going to cooperate, though.

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