Line chart with more than 65535 data values

  • Thread starter Thread starter m4nd4li4
  • Start date Start date
M

m4nd4li4

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
 
Do you have a 50 foot roll of paper to print it? Otherwise the data points
will be lost!
 
m4nd4li4 said:
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
Click to expand...

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
 
Make that 4 problems.

4. If you don't reduce the data as mentioned in #3 of my previous
message, the chart will truncate the data series after 30,000 values.
So you'll need to at least break up the data into blocks of 30,000
points.

Perhaps other people will post here even if they know how to solve just
1 of the 4 problems, and eventually a complete solution may emerge.

Mark
 
redbelly said:
Make that 4 problems.

4. If you don't reduce the data as mentioned in #3 of my previous
message, the chart will truncate the data series after 30,000 values.
So you'll need to at least break up the data into blocks of 30,000
points.
Click to expand...

32,000 in Excel 97, I believe.
 
maximum 32,000 points per series, 256,000 points per chart. This is the
Excel limit, but the visibility limit is substantially lower.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Many thanks for replying. The data is collected from an instrument and
the settings cannot be changed. Therefore I cannot average 10 points as
suggested earlier.

What about using VB6 to extract the first 5000 numbers from the
textfile saving them in another textfile, then another 5000 numbers,
etc,etc....??

Regards,

Bharesh
 
You could do that in Excel also using the same VB file system
manipulations, and dump the data into worksheets.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top