Sheet level association

[#1]

Hi,

       i attached two files one is Sheet1 and other one is Sheet2.

My requirement is suppose i click on year (List box) values, i need to display corresponding values in Sheet1 only,no need to display in sheet2.

Can we do this one.

[nagarjuna_kotha]

Hi,

Yes its posible.

But one suggest from my end.u have two chat in sheet 1 and sheet2 .are the two charts are in same year or different?

Let me know

Regards,

nagarjuna

[niccolo_chiodar]

You can use alternate states. Add two alternate states in document setting, set the listbox and the chart you want to change on a state, the other chart on another state (or just leave it to inherited).

Niccolò

[stabben23]

Hi,

Use a Trigger on Sheet Properties, add Action OnActivateSheet, clear All for ex.

[gizzel123]

Hi Sharath,

Use Alternate States . Create 2 alternate states.One for Sheet 1 and Another for sheet 2. Then in the objects you want to associate , keep them in the same alternate State.

In the setting Tab: Go to document Properties to create 2 Alternate States.

Then in the chart GENERAL properties, make the chart in the required Alternate State.

Hope this helps.

[#6]

Thanks Gizzel for your helping.

[gizzel123]

You are most welcome.