LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
JLB
 
Posts: n/a
Default Data point location

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

"Jon Peltier" wrote:

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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Point labeling Russell-stanely Charts and Charting in Excel 1 September 16th 05 08:15 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
How to remove a data point in a chart? Vicky Charts and Charting in Excel 6 July 15th 05 05:27 PM
Stock Location Sorting Problem mark1caroline Excel Discussion (Misc queries) 3 July 13th 05 03:53 PM
Removing blank rows in a worksheet Louise Excel Worksheet Functions 6 May 26th 05 02:21 PM


All times are GMT +1. The time now is 03:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"