Disable screen updating, and remove the selection from your code. I can
imagine setting the chart height to zero while working on it will have
unexpected consequences.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"halfpint" wrote in message
...
I've also been very frustrated with the very slow charting of 2007 with
vista. I've had to spend a lot of time modifying my macros to eliminate
"select" because it drives a lot of cpu. One trick I've found that works
is
to put the graphs in a row and then "hide" the row while I generate the
graphs with the macros. Once the graphs are created/modified with the
macros
I then "unhide" the row/graph. It speeds up the time greatly
--
halfpint


"Norm" wrote:

I have spreadsheets going easily from 16000 to 64000 lines, I used to
make
EXCEL 2003 charts by using 3-4 worksheets easily. They were big but ran
very
fast. EXCEL 2007 is simply very slow, even if I try to do a chart from
scratch.

Simple line charts, scatter points nothing graphically demanding and my
computer is a P4 full of memory.

Anybody out there with the same problem?

Norm