m4nd4li4 wrote:
Hello,
I have a text file with each data (from instrument) separated by
comma, ie it looks like this....
123.0,111.0,100.0,98,0,254.0, etc, etc,
As you can see, it is just one row of data. The text file usually has
more 65000 of these data. Is it possible to plot this data using line
chart? These data values will be on the Y-axis. Any suggestions willl
be greatly received.
Many thanks,
Bharesh
As I see it, you have three problems to deal with.
1. The data must be transposed from a single row format to a column
format.
2. The data takes up more than the 65k limit of Excel
3. Even if you overcome issues 1 and 2, your chart and Excel file
might be quite cumbersome to work with because of the large data set.
You might consider either averaging every 10 points into a single data
point to reduce the total number, or breaking the data set into
separate, more manageable blocks.
Mark
|