PC Review


Reply
Thread Tools Rate Thread

How do I determine the Left & Top coordinates of a graphed point?

 
 
=?Utf-8?B?bGFrZW0=?=
Guest
Posts: n/a
 
      14th Nov 2006
In Excel Visual Basic, how do I determine the Left and Top coordinates of a
graphed point. The points are graphed using a Visual Basic module. I need
to be able to place a text box above selected graph points but need to know
the relative coordinates of the point on the chart.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?VG9tIE9naWx2eQ==?=
Guest
Posts: n/a
 
      14th Nov 2006
maybe apply datalabels and look at the left and top property of those.

--
Regards,
Tom Ogilvy



"lakem" wrote:

> In Excel Visual Basic, how do I determine the Left and Top coordinates of a
> graphed point. The points are graphed using a Visual Basic module. I need
> to be able to place a text box above selected graph points but need to know
> the relative coordinates of the point on the chart.

 
Reply With Quote
 
Jon Peltier
Guest
Posts: n/a
 
      15th Nov 2006
Or maybe just use the data label.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Tom Ogilvy" <(E-Mail Removed)> wrote in message
news:FFFD5C75-760D-4AFE-A9D7-(E-Mail Removed)...
> maybe apply datalabels and look at the left and top property of those.
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "lakem" wrote:
>
>> In Excel Visual Basic, how do I determine the Left and Top coordinates of
>> a
>> graphed point. The points are graphed using a Visual Basic module. I
>> need
>> to be able to place a text box above selected graph points but need to
>> know
>> the relative coordinates of the point on the chart.



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Top and Left Coordinates Dave Microsoft C# .NET 0 15th Sep 2010 11:17 AM
What is the Cell address of a Graphed point? Aaron Microsoft Excel Charting 1 27th Mar 2008 09:15 AM
How to determine coordinates on a pre-printed form =?Utf-8?B?Smlt?= Microsoft C# .NET 0 3rd Jan 2007 03:33 AM
Convert point coordinates -> pixel coordinates Zorro Microsoft Excel Programming 1 1st Jun 2006 03:26 AM
Converting MouseDown Coordinates to Chart Point Coordinates Steve Microsoft Excel Programming 3 2nd Dec 2003 06:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:59 AM.