How to display Hiding chart

[madhubabum]

Hi all

I have the following scenario

I have the year list box : 2012 , 2013 , 2014 , 2015 ,2016

Note : If i selected the particular Year , Then only the related chart will be displayed .....

           Other wise , If i click on  " Clear "  Then the chart will not be displayed.....

How we can display the chart, if i click on clear.

Thanks

Madhu

[arulsettu]

go to chart properties

in layout ->conditional

try like this

if(year='2012',1,0)

do for the other years with relevant charts

[pokassov]

Hello!

Layout. Show. Conditional

=if(year=2013,1,0)

[Anonymous]

Hi

Chart Properties>Layout>Show Enable Conditional

Give expression like this : if(year='2012',1,0).....

Hope it helpz

[Kushal_Chawda]

go to chart properties

in layout ->conditional put below expression

if(getselectedcount(Year)=1,1,0)

[madhubabum]

Hi

Thanks for reply ...

But still hiding

[arulsettu]

in document properties->security-> uncheck show all the sheets and objects

[madhubabum]

Hi

It's Already Unchecked

[madhubabum]

Hi

Arul Settu

Note : Hiding Means "my Chart object is minimizing "(Does not show the values)

[Kushal_Chawda]

Please clear your requirement.