Open charts by clicking on cells

[#1]

Hi all,

Can we open a another charts by clikcing on Pivot table cells.

In attached image contains 36 cells in pivot table , if i click on any of the cell that should open that particular chart.

Is this possible  Or any best way to approach this ?

Greatly appreciated to all sharing your experience on this.

Thanks in advance.

Regards,

Satish .A

[#2]

why don't you replace three green rows by 3 buttons (one for each type?)

[#3]

Hi sorry for late reply,

All the calculated conditions of Red, Yellow, Green should show in pivot table and should not use it in button.

Please find the attached sample app, that might helps you finding what i'm trying to acheive.

If i click on first column of 'Dia' in pivot table then the below first text object should show and rest of the other objects should hide.

Please let me know is this possible ?

Thanks in advance.

Regards,

venkat

[#4]

i still don't  uinderstand why you want to do it that way

but

check att qvw