layot conditinal

[Anonymous]

hi,

i have 2 pivot at the same sheet ,

i want to expose tham only when the main pivot is open.

ch53 is the main , ch85 is the Secondary ,

only when i open ch53 i want that ch58 will be open also ,

and when i Minimizes ch53 ch85 will be Minimizes too.

is it possible ?

thanks'

yarin.

[tresB]

If you try with macro or trigger, that is doable. In that case you have to use a button to minimize or maximize the charts, i.e, if you click on a button say 'Minimize' all the three charts will get minimized(other charts will remain intact) and if you click on 'Maximize', all will get maximized.

[Siva_Sankar]

pfa. Its using a button to do it.

[Anonymous]

hi,

thanks',but..

when i max , than it's open as max as possible i need that i will be open regular.

[Siva_Sankar]

PFA. Is this you want?