text boxes and arrows on charts/graphs to move with the dates?

Does anyone have a solution to the problem that easily enables text boxes and
arrows on charts/graphs to be tied to the dates. I often insert a text box or
an arrow on a chart to denote a date that a signifcant event occured. My
problem is that as time moves on the text boxes do not keep aligment with the
dates.

Instead of a regular text box, I would suggest adding a data label (say, the
series name) to the specific point you want the info attached to, and then
editing the label to reflect the actual info that you want conveyed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"text boxes and arrows on charts/grahps" wrote:

Does anyone have a solution to the problem that easily enables text boxes and
arrows on charts/graphs to be tied to the dates. I often insert a text box or
an arrow on a chart to denote a date that a signifcant event occured. My
problem is that as time moves on the text boxes do not keep aligment with the
dates.

Hi,

This may help
http://www.andypope.info/ngs/ng47.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"text boxes and arrows on charts/grahps" text boxes and arrows on
wrote in message
...
Does anyone have a solution to the problem that easily enables text boxes
and
arrows on charts/graphs to be tied to the dates. I often insert a text box
or
an arrow on a chart to denote a date that a signifcant event occured. My
problem is that as time moves on the text boxes do not keep aligment with
the
dates.