instant realtime data charting

[dtvonly]

Hi. I have a system that reads in data from an acquisition system. Currently I am sending the data out to Excel. I would also like to graph/chart each data points as they come in.
The X-axis represents data acquisition time (data is read once every, say 1 second, or 2, depends on user selection), while the Y-axis is the actual data.

How do I graph in real-time these data to an Excel chart?

Thank you.

[Andy Pope]

Search for dynamic named ranges, there are many many posts on this topic.

Or create a table and base your chart on that. New rows added to table will automatically be included. for xl2003 tables are called lists.