View Single Post
  #23   Report Post  
Posted to microsoft.public.excel.charting
Juan M. Russo Juan M. Russo is offline
external usenet poster
 
Posts: 1
Default Pls confirm 2007 chart redraw is up to 10 times slower than 20

Hello,

We are an R&D facility and we use excel almost all the time to plot scatter
charts (x,y) with 10000+ datapoints and we have the sluggish unberable
performace. I 'begged' for the fix and installed SP1 afterwards and I still
have the same slow performance. Actually I dont notice any difference.

Has there been any improvement in this matter ??

Thanks

Juan



"Steen T." wrote:

Hello

You are right. If nobody has done anything about the problem since your post
in March - a good 7 months should allow something - I hope my post has added
some fuel to the fire.
--
Steen


"Martin Brown" wrote:

On Nov 5, 11:14 am, Steen T. wrote:
Hello

I have just upgraded from Office pro 2003 to2007and have exactly the same
experience as mentioned in the above threads inExcelbut even worse - my
worksheet calculates a graph from a simple 4 columns by 1200 rows section
with no formulas only numbers - it was working well in 2003. In2007it takes
UNBEARABLY longer to the point of being useless !!! . I am using 2.2 GHz AMD
64x2 dual core, 2.0 GB Ram Have I wasted my money on the upgrade?


Do you really need to ask?

Is there
anything I can do to improve performance or will Microsoft do something about
it ? What happened to the dual processor feature?


You could beg for the hotfix. That makes it slightly more bearable, or
alternatively if you are in the UK you could try rejecting the product
as not fit for purpose. It is about time somebody took up the cudgels
on this one.

XL2007 was not ready for release and still isn't. It might get better
after SP1 if we are lucky.
Numeric formatting problems with the simple calculation =77.1*850 does
not inspire confidence.

And I have seen a few larger complex graphs where it is quite a bit
more than an order of magnitude slower.

"Mike Barlow" wrote:
Hello

I believe that ANY Office2007program that runsslowerthan Office 2003
on the *same* problem or application is a defacto software downgrade. Some
of these problems may be due to new features that have not been fully
optimized yet, but I regard any new feature that slows down software
execution to be a mistake -- a mistake that should be fixed. Software
slowdown due to larger problem size is natural, but delays due to cosmetic
new-features should not be allowed.


A 10% slowdown to have more rows or columns would be worthwhile, maybe
even 50%. That level of overhead can be absorbed in a hardware upgrade
or by adding extra ram. But what we have here is a 1000% slowdown for
daring to have user defined axis scaling on graphs with modest amounts
of data.

It works OK if all you ever plot is sales figures by quarter. But it
is dead in the water at present for many scientific users with
datasets of a few thousand points which used to work perfectly in
versions 2000 through 2003.

I believe that Office2007will not gain wide public acceptance if it is
perceived to be excessively slow as indicated by some of the previous posts
here.


I wish I had your confidence. It seems most users are as dumb as
Microsoft thinks they are.

Perhaps more effort should be devoted to optimizingExcelfor
math-intensive, high-speed processing of large data arrays.


Some slowdown in the larger more capable model was inevitable, but I
don't believe this particular problem with the graphics is related to
the grid size. It looks more like daft cosmetic display features
trumping functionality.

"Nick Hodge" wrote:

David

RTM charting is a 'little' better, but very much still to be improved (I am
sure in v.next). Quoting the 1000000 rows (You didn't mention 16k columns)
is something I believeExcelusers, for it is they who demanded them, will
rue the day they did. It's a limitation of current machine power (Generally
available) and the tasksExcelis put to that make me very sceptical.

Anything approaching the old limit of 65k, should IMHO, be in a database.

Charting *will* get improved but is disappointing in this version.


A polite way of saying almost useless. It would be difficult to make
charting any worse :(

Regards,
Martin Brown