Forum Discussion

Copper Contributor

Jun 01, 2023

Chart with Big Data set

Hi, I have an Excel file which contains 3 tabs such as "A", "B" and "C". The "A" tab has a data table where 16k rows of data are added programmatically, with 7 legends I have created a combo chart i...

Copper Contributor

Jun 02, 2023

it is big data that you make many cells use random function and your chart wil every click make the big date do random calculations so you can use from tab formulas -calculations option -manula so you contron the update of chart when you want by clculate now

Krishnan1989
Copper Contributor
Jun 02, 2023
How to do that? Any sample or any examples?
- abdelazizallam
  Copper Contributor
  Jun 03, 2023
  Krishnan1989
- mtarler
  Silver Contributor
  Jun 03, 2023
  Krishnan1989 so I don't see that behavior but will try more later. Also, I don't know if this file uses all those RAND functions just to create a sample or if your actual file has lots of RAND() but those are volatile functions meaning excel re-calculates them and every cell dependent on them on every calculation iteration which will cause huge hits to performance ( you can search for excel volatile functions for more information). I believe that is what is being noted in the response above and that you can also turn off automatic calculation updates under Formula menu and selecting 'Manual' instead:
  this does mean when you make changes and you actually want everything to update you need to hit the calculate now button.
  - Krishnan1989
    Copper Contributor
    Jun 03, 2023
    mtarler Random function is used for sample data. For me when I clicked the chart drawn area multiple times, I'm getting the above mentioned issue.