Adding pinned arrows to a chart

[RealRaven]

Hi!

Is there any way to add an arrow that points to a specific coordinat
in the chart, even if it resizes? I want to point out interestin
things in a chart I have

 

[Bernard Liengme]

1) click on chart
2) from Drawing tool select the line with arrow
3) draw line
best wishes

 

[RealRaven]

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.

 

[Jon Peltier]

Drawn shapes are not pinned to specific chart positions, and sometimes move
on their own even if the data or axes don't change. However, you can use
drawn shapes as custom data markers, and they will move with the axis
scales:

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

- Jon

 

[Del Cotter]

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