Clicking a particular chart value

[#1]

I have a line chart by year and head count based on hire and attrition.when I click on the particular year and hire line it should transfer those values into a next sheet...what I have now it does transfer the year but the hire number based...wrote a script to trigger the sheet...

sub NxtSht
set val=ActiveDocument.Fields("Years").GetPossibleValues
Set var = ActiveDocument.GetVariable("vList")
if val.Count = 1 then
for i=0 to val.Count-1
var.SetContent val.Item(i).Text, True
ActiveDocument.ActivateSheetByID "SH08"
next
end if

End sub

the current chart is attached...if I click on 2011 and 1447 (term) then it should transfer the year and term(it is a calculated value) to the next sheet..

It has become a challenge...any help would be appreciated...

[#2]

Updated the chart to get it better...still not able to transmit particular values... !

[#3]

I need to capture legend values and transfer that into a another chart....

[#4]

hid a textobject and transparency to 100%..it works