Finding which axis label was selected?
 

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

Finding which axis label was selected?
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


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