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.

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" <(E-Mail Removed)> wrote in message
news:949360BE-1157-4A41-B3C1-(E-Mail Removed)...
>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.

Andy,

This was great...it was exactly what I needed.

Thank you!

Jay