Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

Is there a way to disable screen updating while reformatting the Excel 2007 chart?

Dialog box for formatting

share|improve this question
up vote 2 down vote accepted

AFAIK there is no setting to disable the chart update while the formatting dialogs are shown. As a workaround, you could use a smaller data set while you are formatting the chart. Once you're happy with the look, assign the real data set.

share|improve this answer

Sounds like you have Automatic Calculations turned on. This function recalculates the entire workbook when any value is changed.

If set the calculation option to Manual, the workbook will not update until you tell it to.

enter image description here

You can press the Calculate Now button or press F9.

Note: I am using 2010, so the image may not be exact.

share|improve this answer
Yeah, tried that. I think my issue is caused by Excel redrawing the chart before I am finished changing a formatting value. – njivy Jan 29 '13 at 17:17

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .