Graphing Large Amounts of Data

  • Thread starter Thread starter BSc Chem Eng Rick
  • Start date Start date
B

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
 
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
 
Back
Top