Jun 01 2023 08:31 PM
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 in tab "C" by using the table in "A" tab. Everything is working fine, the problem was, if I click one of the chart series from the chart and suddenly click another series from the same chart then the Excel getting stuck/hang for a few seconds and then recovered back. Please advise anyone to overcome/fix this problem.
Note - With 7 Legends - 4 are Primary and 3 are Secondary
Thanks.
Jun 02 2023 08:41 AM
Jun 02 2023 10:09 PM
Hi @mtarler,
Thank you for the reply. I have attached a sample Excel file, as I mentioned in the above discussion play with multiple clicks on the chart (click on the chart's plot area/click on the points) then move into a different file such as My Computer or any other program in the PC/Laptop then come back and see the excel may hang. Also, see the performance of the Task Manager. it goes high. Please let me know if you want any further clarification.
Thanks.
Jun 02 2023 10:48 PM
Jun 03 2023 07:41 AM
@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.
Jun 03 2023 10:06 AM
@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.
Jun 03 2023 12:43 PM