ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I determine the Left & Top coordinates of a graphed point? (https://www.excelbanter.com/excel-programming/377323-how-do-i-determine-left-top-coordinates-graphed-point.html)

lakem

How do I determine the Left & Top coordinates of a graphed point?
 
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.

Tom Ogilvy

How do I determine the Left & Top coordinates of a graphed point?
 
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.


Jon Peltier

How do I determine the Left & Top coordinates of a graphed point?
 
Or maybe just use the data label.

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


"Tom Ogilvy" wrote in message
...
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.





All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com