Finding which axis label was selected?

R

Rominall

Is there a way to determine which axis label was clicked? Example: Chart by
month. If they click on March, can I detect that?
 
J

Jon Peltier

Using chart events, Excel can only tell which axis was clicked. However, you
could convert the coordinates of the click to a position on the chart, and
match this to the placement of the labels. It's probably easier to get the
category by having the user click on a point.

Here's an introduction to chart events:

http://www.computorcompanion.com/LPMArticle.asp?ID=221

- Jon
 
Top