View Single Post
  #2  
Old November 7th, 2005, 08:18 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default Data point location

I use the calculated X and Y positions of points in these examples to
draw other features:

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

The code is not so complicated that you couldn't see how to draw your
own objects according to plotted point positions.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


JLB wrote:

I'd like to be able to determine the location of a data point relative to the
chart object. My goal is to automate the drawing of a horizontal arrow
between 2 series that form vertical lines on an XY scatter plot (similar to
the dimension lines on an engineering drawing). Is this possible?