Graphing Large Amounts of Data
 

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

Graphing Large Amounts of Data
 

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