I have a chart with about 70,000 data points. When I format the axes or data series, Excel automatically updates the chart before I am finished editing the value. This is very slow (1+ minutes), even with my 3.30-GHz, 8-core, Windows 7 Enterprise machine with 8-GB of memory.
For example, if I want to change the line width from 2.25 to 1.5, every time I type or delete something, the chart updates. Tedious!
Is there a way to disable screen updating while reformatting the Excel 2007 chart?