If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data point location
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
multiple docs, one data source | kp | Mailmerge | 12 | January 31st, 2005 05:41 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 03:54 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |