VBA plot area axes coordinates

[cnestg8r]

I know how to get pixel coordinates from a mouse click. I also know how to get the axes values from a series (or point selected). How do I get the axes coordinates from a mouse click in the plot area whether it hits a series, point, or open space?

 

[bensonsearch]

Hi,

im not to sure what you are asking (i get confused dont worry) but you can always set a value to = the x or y axis points eg

msgbox(textbox1.left)

 

[cnestg8r]

Excel charts have a defined "plot area". I would like to mouse-click a point in the plot area space and return axes values (Scatter Chart) that may not be on a series.