I have a sheet contains 3 charts, and all of them have complex calculation in Expressions. It takes ages when I try to open this sheet, the three charts are processing at the same time. So is there any way i can control that Chart 1 will calculate first, when it finish, Chart 2 start processing, ten Chart 3.
It is highly recommended to place your formulas, specially the complex ones, in the load script. It will save you a lot of time in terms of performance.
Regarding to the calculations, I don't think there is a way to do what you're trying to do.
