How to cancel tedious Excel charting operation without crash

5

1

I'm charting about 17,000 data points in Excel. Needless to say charting is slowwww.

I accidentally selected the wrong chart type (Bubble thing?) and it is loading forever. I did not save my last changes.

Is there any way to cancel the operation without crashing Excel and losing my work?

It's been 6 minutes and Excel is still loading.

UPDATE: After 10 minutes the chart appeared and I was able to change the type, but I would still like an answer for future references, if possible.

Petrus Theron

Posted 2010-09-30T11:38:39.157

Reputation: 285

Answers

0

No there are no way.There are no cancel button or something.Probably you could write some macro for graphs you could include a cancel button there probably.

Yakov

Posted 2010-09-30T11:38:39.157

Reputation: 339

Next time I'm waiting for my chart to load, I'll write a macro :) – Petrus Theron – 2010-10-06T14:17:03.470

Asked: 2010-09-30T11:38:39.157

Viewed: 1 653 times

Active: 2011-09-11T14:15:21.383