Forum Discussion
Why excel crashes or runs extremely slow when I'm trying to plot data and edit series?
It depends on the amount of data on the one hand.
On the other hand, an SSD hard drive in such amounts of data cannot do any harm.
Since it is a DELL, I recommend that you carry out all new driver updates and update the BIOS, especially if you are working with Windows 10 Pro.
Also look in the Config.sys whether the RAM is fully available to the system.
Call config, sys:
In the text search, write "msconfig" and enter.
The system configuration window appears.
Go to start Click on Advanced Options ...
Maximum memory: check the box.
Ok and enter System configurator requests a new start.
Perform a restart.
Hope I could help you at least a little with this info’s.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
NikolinoDE Thanks for the reply
I have all the latest updates for the drivers and graphics and the latest version of the bios.
I tried what you said, the file i uploaded still crashes. The way it goes it takes ages to open the plot and says excel not responding. If you let it be it comes back to life but if you click something or move the plot or try to edit the series it crashes again. If you wait again it comes back to life but any click anything will trigger it again. It's not the PC because you can roam through the rest of the apps with ease while excel is not responding. So I don't know what to do
Thanks for your help btw fellas, appreciate it
- SergeiBaklanJan 17, 2021Diamond Contributor
You plot scatter chart using entire columns as data, i.e. Sheet1!A:A as X-axis and Sheet1!C:C as Y-axis. That million of points on which Excel shall do million of millions calculation. It's hard to expect such recalculation will be fast, doesn't matter which hardware do you use.
Please use dynamic ranges for the chart. That could be different approaches, in attached file I illustrated one of them on one series:
Using Formula->Name Manager add named formulas which return dynamic ranges
As data for the chart series use =Sheet1!kp10X and =Sheet1!kp10Y for x and y axis's. When save Excel transforms sheet names to file name since we used workbook scope for named formula, you may ignore that effect
Finally no problems with recalculations. In attached is only one series, but I believe if you add by same way dozens of more that won't affect performance significantly.
- MaximosGatosJan 19, 2021Copper Contributor
Thanks a lot SergeiBaklan and the rest of the lot
I simply plotted the chosen cells using shift and control and it's fine now.
I feel stupid. Sometimes the answer is right beneath our nose.
Thanks again
All the best Max
- JKPieterseJan 20, 2021Silver ContributorNext time you create a chart, format your source data range as a table. If you later add data tot he table, the chart grows with it automatically. Just as formulas will.