View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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.