Forum Discussion
Chart with Big Data set
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.
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.
- I'm just not getting the same behavior. I even changed the rand() function to create separation so i could easily click between the series (i.e. =RANDBETWEEN(50*column(), 50*column()+100)
but I'm not getting any lag or issues even with autocalc set on. In you device manager how much memory is used? If you are getting close to full memory usage then that could be the issue.
