Get the axis label from a selected serie in a Chart

[JuanPa]

If I select a specific point from serie in a chart, I get three parameters:
- ElementID, the selected item, in my case, xlSeries
- Arg1, the SeriesIndex
- Arg2, the PointIndex

So, if I want to know the description of the Serie,

? ActiveChart.SeriesCollection(Arg1).Name

But, if I want to know the Axis description for this point, I suppose

? ActiveChart.SeriesCollection(Arg1).Points(Arg2).Name

My problem is that the result there is something like "S2P1" (Serie, Point).

How can I get the axis label for a selected point? Something more like "Europe" (category name). Thanks!

 

[pgc01]

Hi
Welcome to the board

Try:

Dim vXValues As Variant
 
vXValues = ActiveChart.SeriesCollection(Arg1).XValues
 
MsgBox vXValues(Arg2)

 

[JuanPa]

Works like a charm, thanks a lot!