Selection in Chart

[#1]

I have a field called Plan under which i have many plans. The same field i have used for creation of two charts where that plan is used as dimension.

Now if i select a Plan in Chart 1 i want that to take me to other sheet but if i select the same plan in chart2 i want to remain in the same sheet. how that can be done ??

I have attached a sample QVW file. Right now selection in both the chart is taking me to next sheet. I want only chart 1 to take me to next sheet.

[#2]

Hey,

Find the attachment.Is that you looking for

Thanks,

Jai

[#3]

No,

My requirement is that when i click on any plan in Chart 1 it shouls take me to next sheet and if i click on any plan in chart 2 it should remain in the same sheet.

[#4 · Accepted solution]

I used this code and its working fine.

sub abc



if ActiveDocument.GetSheetObject("CH01").IsActive then

set x = ActiveDocument.GetCurrentSelections

s = x.Selections

v = x.VarId

for i = lbound(s) to ubound(s)

if v(i) = "Plan" then

ActiveDocument.ActivateSheetByID "SH02"

end if

next

end if



end sub

But can i do it without using macro