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