Forum Discussion

Krishnan1989's avatar
Krishnan1989
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 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.

Charting
developer
excel

8 Replies

  • abdelazizallam's avatar
    abdelazizallam
    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
  • mtarler's avatar
    mtarler
    Silver Contributor
    Jun 02, 2023
    That is really hard to answer as there are many things it could be. Simply having 7 plots each with 16k data points is a starting point. Do you have any custom formatting on the chart? You may also have other parts of the workbook causing issues. If you have 365 you can try opening using the online version and under the 'Review' tab is a new feature called 'Check Performance' which might help find areas to improve performance.
    • Krishnan1989's avatar
      Krishnan1989
      Copper Contributor
      Jun 02, 2023

      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.