Hi all,
I need a code to show the X,Y coordinates (on the status bar for instance) of any position on the chart when moving the cursor on it.
I used Microsoft code but there is always the message of ( Compile Error)...
Please help!
Cheers
Ralem
Hi all,
I need a code to show the X,Y coordinates (on the status bar for instance) of any position on the chart when moving the cursor on it.
I used Microsoft code but there is always the message of ( Compile Error)...
Please help!
Cheers
Ralem
It would help if you posted what you had or even a link to the MS article.
Errors not withstanding the main problem is the conversion of mouse xy coordinates and the charts xy coordinates and the scaling of the data contained within the chart.
You can capture the mouses xy values in the mousemove event. But these values do not correspond with the charts left/top etc values.
Any conversion is futher complicated by the zoom factor of the chart.
What exactly are you trying to do?
Thanks Andy for the reply, Below is the link:
http://support.microsoft.com/kb/152969
What I'm after is that I have a workbook with a chart where I set a map as a background and made X,Y of the cart axis the same as of the map, I like to add the ability of showing X,Y values when pointing the mouse somewhere on the map/chart, is it possible?
Cheers
Ralem
The chart has mouse events you can capture. As I say the hard part is converting between coordinate systems.
To make things easier you can get the user to click top/left and bottom/right of the plotarea. Then you can more easily convert between mouse and chart and data values.
http://www.computorcompanion.com/LPMArticle.asp?ID=221
Have you seen this addin?
http://tushar-mehta.com/excel/softwa...ata/index.html
I believe it can be done somehow by only moving over the chart, and have seen it programmed by java, must be able to be done by VB....
I'm sure it can.
You just have to find the correct formula for all the different coordinate systems.
no it's only one coordinate system which is the chart, the map has same coordinates?
you have to deal with the following,
x and y scale values
left and top properties of the chart
x and y mouse coordinates
If you find out please let me know,
Thanks
Ralem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks