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,
But, if I want to know the Axis description for this point, I suppose
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!
- 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,
Code:
? ActiveChart.SeriesCollection(Arg1).Name
Code:
? ActiveChart.SeriesCollection(Arg1).Points(Arg2).Name
How can I get the axis label for a selected point? Something more like "Europe" (category name). Thanks!
Last edited: