Line chart with more than 65535 data values
 

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!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"m4nd4li4" wrote in message
om...
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

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

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" wrote in message
oups.com...
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.

32,000 in Excel 97, I believe.
--
David Biddulph

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/
_______


David Biddulph wrote:

"redbelly" wrote in message
oups.com...

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.


32,000 in Excel 97, I believe.
--
David Biddulph

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/
_______

m4nd4li4 wrote:
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