I've spent many a year as an Access developer (professionally) I learned graphing in version 2.0 (that was a lonnng time ago). The database will have no problems with your 2M sample set, but as others have pointed out the point density on such a graph would exceed your screen or printer. 2M data points / 600 DPI printer / 12 inches per foot = 280 foot long chart. -Denny ----- Original Message ----- From: "James Nick Sears" To: Sent: Monday, November 24, 2003 8:40 PM Subject: Re: [OT]: Graphing > Now that you say this I think it is only the last version(s) of Access (I am > using 2002) that have this functionality, or at least it is drastically > expanded in this version - if I remember correctly. In any case 2002 > definitely has it. > > Nick > > ----- Original Message ----- > From: "Jake Anderson" > To: > Sent: Monday, November 24, 2003 6:28 PM > Subject: Re: [PICLIST] [OT]: Graphing > > > > I did not know acess could produce graphs. I shall look at this thanks. > > > > -----Original Message----- > > From: pic microcontroller discussion list > > [mailto:PICLIST@MITVMA.MIT.EDU]On Behalf Of James Nick Sears > > Sent: Tuesday, 25 November 2003 9:42 AM > > To: PICLIST@MITVMA.MIT.EDU > > Subject: Re: [OT]: Graphing > > > > > > Have you looked at Access? That's what I'm using so far to plot for my > > datalogger project. I'm not totally satisfied and hope to find something > > more appropriate but it's getting the job done. I hold all of my real > > samples in a table and then if I want to do a moving average or whatever > > other kind of analysis I just write a quick function in VC++ to calculate > it > > and save the results to a new table (or to the same table with a > > distinguishing index value for all the records) and look at it with the > > "PivotChart" view. It also does smoothed curves on its own but it doesn't > > seem very user configurable as to the nature of the smoothing (or maybe I > > haven't looked hard enough). > > > > Definitely the DB can hold more than 65k samples but I can't tell you how > > PivotChart will respond to the load. But it gives you an relatively > > convenient platform to do PC processing on the data to get the chunk or > the > > downsampled data that you need. > > > > Nick > > > > > > > > ----- Original Message ----- > > From: "Jake Anderson" > > To: > > Sent: Monday, November 24, 2003 6:55 AM > > Subject: Re: [PICLIST] [OT]: Graphing > > > > > > > I want to look through the data to find bits of it that are interesting. > > > cuttently the interesting bits are already > 32k samples > > > > > > I want to see moving averages, smoothed curves a whole bunch of stuff > and > > > there must be something better that excel out there for doing that lol. > > > > > > > > > > > > -----Original Message----- > > > From: pic microcontroller discussion list > > > [mailto:PICLIST@MITVMA.MIT.EDU]On Behalf Of Russell McMahon > > > Sent: Monday, 24 November 2003 10:57 PM > > > To: PICLIST@MITVMA.MIT.EDU > > > Subject: Re: [OT]: Graphing > > > > > > > > > You can't *see* 65,000 points, let alone 2 million. > > > If you subset the data in an external program Excel will happily plot > > graphs > > > far more detailed than would possibly be useful. If you want to use some > > of > > > Excels advanced features this may not work, but for display purposes > it's > > > fine. As long as the data varies slowly relative to your sampling rate > (ie > > > you obey Mr Nyquist's warnings) then you could just take every Nth data > > > point or process it intelligently. If the data varies "rapidly" then you > > can > > > only view a subset of it in a manner that is meaningful to your > eye/brain. > > > Even plotted along the long side of an A3 sheet a 65000 point data set > > gives > > > about 4000 dpi ! > > > > > > RM > > > > > > -- > > > http://www.piclist.com hint: The list server can filter out subtopics > > > (like ads or off topics) for you. See http://www.piclist.com/#topics > > > > > > -- > > > http://www.piclist.com hint: The list server can filter out subtopics > > > (like ads or off topics) for you. See http://www.piclist.com/#topics > > > > > > > -- > > http://www.piclist.com hint: The list server can filter out subtopics > > (like ads or off topics) for you. See http://www.piclist.com/#topics > > > > -- > > http://www.piclist.com hint: The list server can filter out subtopics > > (like ads or off topics) for you. See http://www.piclist.com/#topics > > > > -- > http://www.piclist.com hint: The list server can filter out subtopics > (like ads or off topics) for you. See http://www.piclist.com/#topics -- http://www.piclist.com hint: The list server can filter out subtopics (like ads or off topics) for you. See http://www.piclist.com/#topics