Adding comments to series and fixing it to a point

#1 05-02-2005, 05:06 PM

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

#2 05-02-2005, 10:06 PM

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/
_______

Nacho wrote:

> 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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)