Forum Discussion
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...
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.
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.