View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton
 
Posts: n/a
Default Pls confirm 2007 chart redraw is up to 10 times slower than 2003

Larry -

Keep in mind that you are not using Excel 2007. Unless you have been able to
time-transport yourself into the future, you are actually using Excel 2007
Beta 2. And you should not expect that a Beta version is optimized for
speed.

- Mike
www.mikemiddleton.com

"larry godfrey" wrote in message
...
I have complex charts, with many data points. The redraw time on my
machine
in Excel 2003 (all updates for office and wxp installed) is 2-3 sec, which
I
consider extremely slow, so I was looking forward to an new chart engine
with
better speed from 2007, but am flabergasted at how slow 2007 is.
Try this...create a line chart, 12 columns of 5000 points each. Put it
imbeded in a worksheet. Tab to another worksheet, tab back, time the
redraw.
On my machine (3 ghz, 2gig ram), redraw time is 2-3 sec for all the lines
to
show up on the graph. In 2007, it takes a full minute! the graph looks
better (lines are more clear), but wow, this redraw time is crazy! I
created
the graph in 2003, pulled it into 2007 and saved it as 2007.xlsm file
type.

I also have a graph with ~ 50 5k point lines, of which I hide most of them
at any one time. This chart redraw in 2007 can go on for 5 minutes!
(compared to 10-15 sec in 2003)

Am I unaware of some setting to speed things up, or did MS realy make
charts
10X slower to redraw?
Best regards
Larry