A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data point location



 
 
Thread Tools Display Modes
  #1  
Old November 7th, 2005, 04:05 PM
JLB
external usenet poster
 
Posts: n/a
Default 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  
Old November 7th, 2005, 09: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?

  #3  
Old November 7th, 2005, 11:01 PM
JLB
external usenet poster
 
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
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 10:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.