As far as I've been able to discover, you cannot turn off the ridiculous
formatting in Excel 2007 charts. Each marker has to be drawn with a
potential graduated shading and 3D effect in mind. This and probably
infrastructure required to handle the much larger grid have made charting a
slow and tedious process to watch, and the user interface has made it a slow
and tedious process to undertake.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"BSc Chem Eng Rick" wrote in
message ...
TWIMC
I have a datalog which contains a large amount of info (+10000 data
points).
When I try and plot anything more than 1000 points in Excel 2007, the app
starts to labour quite seriously and takes forever to fomat a simple thing
like axis scale.
I assume that this is because the new Excel has some pretty fancy
formatting
options and it also runs live previewing as formats are changed within
dialogue boxes. Is there a way to just draw simple scatter plots without
any
of the processor consuming embelishments? I just need basic formatting
functionality.
Thanks