Minimized Vs Hidden

[#1]

Which is the best option to put the Chart Object in the Sheet?

By Making them Restored or Hidden?

[b_garside]

I usually go for Hidden. Then I link it to a button using a variable. Using the Show condition

[#3]

Ok. I know the Minimized objects are calculated when they are Restored / Maximized. Is it same fro Hidden Items?

Are they caluclated only when they are visible?

[b_garside · Accepted solution]

Correct; Hidden/Minimized prevents it from being calculated. I heard some differing view points but my testing has shown this to be true.  

[#5]

ok. Thank you. So

Hidden & Minimized objects will be calculated only on demand. So the Best way is to use Hidden beacuse it saves no.of triggers applied on the button.