Forum Discussion
Why excel crashes or runs extremely slow when I'm trying to plot data and edit series?
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.
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
- Next 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.
MaximosGatos , glad to help. If you have static data which is practically never changed fixed range works fine.
