I am trying to make a chart that in Excel 2003 takes no time at all to
display. It can involve up to 20 different series (maybe 500pts each). I
end up editing specific series to a common color, and I turn labels and lines
on or off depending upon consecutive data. Again, Excel 2003 took this with
no problems and showed the edits quickly. Excel 2007 locks up!! It can take
5 minutes for the color palette to show up!!
Bernard Liengme - 05 Oct 2007 19:56 GMT
A known problem. We await MS's solution.

Signature
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
>I am trying to make a chart that in Excel 2003 takes no time at all to
> display. It can involve up to 20 different series (maybe 500pts each). I
[quoted text clipped - 5 lines]
> take
> 5 minutes for the color palette to show up!!
Bob Flanagan - 06 Oct 2007 00:45 GMT
Wait until Excel 2009 - it will take several days to do!
>I am trying to make a chart that in Excel 2003 takes no time at all to
> display. It can involve up to 20 different series (maybe 500pts each). I
[quoted text clipped - 5 lines]
> take
> 5 minutes for the color palette to show up!!
JMacC - 08 Oct 2007 14:29 GMT
I found the solution in an earlier post. Follow the link provided below.
Worked well.
Subject: Re: Excel 2007 is SLOW in responding 9/17/2007 7:51 PM PST
By: Jon Peltier In: microsoft.public.excel.charting
> Any idea when MS will issue a fix for this?
Probably in Excel 2010. There's a hotfix that improves the performance of
Excel 2007 from excruciatingly slow to painfully slow:
http://support.microsoft.com/kb/938538
Contact MS service, and they'll send you an email (no charge) with a link to
download the hotfix.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
Jon Peltier - 08 Oct 2007 14:37 GMT
How effective did you find the hotfix in solving your problem?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
>I found the solution in an earlier post. Follow the link provided below.
> Worked well.
[quoted text clipped - 19 lines]
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com