Charts -- drawing arrows to points
 

I have an XY scatter plot and I want to be able to draw arrows from the
origin of the chart to a select points in the chart. Within VBA, how can I
get the location of the both the origin and the points so that I can draw the
arrows? I think I can get the coordinates from the seriescollection, but
that doesn't help me know where to draw the arrows, right?

Any help greatly appreciated. Thanks.

Charts -- drawing arrows to points
 

Hi,

Looks like the blog of Jon's will give you the coding start you need.
http://peltiertech.com/WordPress/200...th-arrows-vba/

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jay" wrote in message
...
I have an XY scatter plot and I want to be able to draw arrows from the
origin of the chart to a select points in the chart. Within VBA, how can
I
get the location of the both the origin and the points so that I can draw
the
arrows? I think I can get the coordinates from the seriescollection, but
that doesn't help me know where to draw the arrows, right?

Any help greatly appreciated. Thanks.