Chart recalculation when moving

[#1]

Hello,

I have a lot of heavy charts, and some of them recalculate when I move them with cursor, wasting time dramatically, but others don't.

How is it controlled?

[sudeepkm]

if you have huge data  then you can use set analysis instead of if else in your chart expression.

if you are already using set analysis then please check your data model in case a Cartesian is formed.

also you can check how much memory the chart objects are taking by looking at the Sheet Properties > Objects > Cal Time

[#3]

thanks, however what I can't figure out is why some objects recalculate when I move them with my mouse pointer, and some others don't. I am using both set analysis, and ifelse.

[prieper]

Think that there is always a recalculation of objects - you can see them sometimes, if the calculation takes longer, sometimes not .....

Recommend not to move objects or to rethink the datamodel

Peter