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?