Data point location

[Guest]

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?

 

[Jon Peltier]

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/
_______

 

[Guest]

Jon, thanks!

Your example answered my question brilliantly. After some translation from
your VBA to my Managed C++, I have what I need.

Thanks again.

--JLB