A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Live data capture and charting speed



 
 
Thread Tools Display Modes
  #1  
Old February 16th, 2010, 12:40 PM posted to microsoft.public.excel.charting
Neil[_9_]
external usenet poster
 
Posts: 1
Default Live data capture and charting speed

Hi All,

I have a project whereby I am capturing live data from a data acquisition unit.
The data consists of voltage readings from two channels plus a timestamp, captured at the rate of 20 (sets of) readings per second populating a worksheet.
I have the capture of data limited to 2400 rows of data per test instance, a total of 2 minutes per test.

I would like to chart this live data so that we can watch the test progress in real time, comparing the x y relationship on a scatter chart.

I'm currently using a dynamic named range to capture only the data available at each point in (excel update) time rather than simply set the range for my chart series to pick up the full 2400 rows of data by two columns (ignoring the timestamp data).
Sometimes the test is terminated before the 2 minutes is reached.

Is this the most efficient (and hence speedy) way of getting data to the charting process quickly ?
Is there anything else I can do to pull the data from the worksheet quicker so as to have less pausing / lag between real time capture and viewing ?

I'm satisfied that the data is reaching the worksheet quickly enough (USB2 input of data stream and the worksheet updates quickly) so I figure the delay / lag is internal to Excel, trying to get the data to the chart...

Any thoughts as to how to improve this situation ?

Many thanks, Neil.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.