Re: How to avoid all sheet object to get load data without current sheet during selection of sheet
That might work. Charts have a Calculation Condition option on the General tab of the properties window. You can use that option to enter an expression that calculates if the chart should be calculated and rendered or not. You can create an expression that checks for selections in one or more fields. Something like =if(GetSelectedCount(MyField)<=10,1,0). You could also use such an expression for the Conditional show option on the Layout tab to hide the chart completely if the condition isn't met.