Storing dynamic data in Excel

[GTstartup]

I have imported dynamic data from an external application to an Excel spreadsheet. The data is constantly changing automatically and I want to trend it on a chart.

How can I sample and store this data in a column or row so I can build a chart with it?



Appreciate any ideas that don't involve heavy VBA.

 

[yakpol]

Try to use named ranges. For example the data will be placed in column A. Go to insert-range-define, name range as data1, in the place for range address type

=offset(A1,0,0,count(A:A),1)

then click ok. Modify this formula to accomodate exact location of your data. When specifying chart series don't forget to type the sheet name

=sheet1!data1

. If the other columns have the same length then name next range

data2 = offset(data1,0,1)

.

Hope it will do!

 

[joerd]

Yakpol's solution to updating the chart is very nice. To update the data in your spreadsheet automatically, look in the menu for [tt]Data/Get External Data/New Database query[/tt].

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.