Getting X axis value on ChartSpace1_SelectionChange

[effie.ram]

I've created 1 chartSpace with 2 SeriesCollection. Both
SeriesCollection getting the data from an array (Value & Categories
for each), No problems.
I'm trying to retrive the clicked Categoty Name by using the following
sub;
----------------------------
Sub ChartSpace1_SelectionChange()
Dim iSeriesNum
Dim iPointNum
If ChartSpace1.SelectionType = 8 Then ' User click on a bar
iSeriesNum = ChartSpace1.Selection.Parent.Index
iPointNum = ChartSpace1.Selection.Index
'msgbox "iSeriesNum :" & iSeriesNum & "iPointNum : " & iPointNum
if ChartSpace1.Selection.Parent.Index = 0 then 'User click on one
of the SeriesCollection(0) item
msgbox AR0_categories(iPointNum)
elseif ChartSpace1.Selection.Parent.Index = 1 then
msgbox AR1_categories(iPointNum)
end if

End If
End Sub
------------------
It's retriving the wrong ualue, it seems that the order of the arrays
was change on the X axis.
Is it possible to get the X axis value of the selection?

TIA, Effie

 

[effie.ram]

Yes, this is exactly what I've been looking for!
Thanks, Effie