Graphing Large Amounts of Data

[BSc Chem Eng Rick]

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

 

[Jon Peltier]

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