Finding which axis label was selected?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to determine which axis label was clicked? Example: Chart by
month. If they click on March, can I detect that?
 
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
 
Back
Top