On Thu, 3 Aug 2006, in microsoft.public.excel.charting,
RealRaven said:
I've tried that. It sure becomes a nice arrow. And I can get it to scale
with the entire chart, but not with the axis. If my x-axis is from 0 to
10 and I draw an arrow right at x=5. Then scale my x-axis to be 0 to
20, the arrow will point at 10, not 5 as I want.

Bernard's suggestion won't work for you because, as you said, you want
the arrow to point at a pair of coordinates on the chart, even if you
change the chart size.

Jon Peltier has the answer you're looking for, with his article "Use an
Arrow to Indicate Special Points":

http://peltiertech.com/Excel/Charts/PointAtPoints.html

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.