Large amount of data for plotting

  • Thread starter Thread starter dharshanie
  • Start date Start date
D

dharshanie

hi there! Thanks for this great forum and all you valuable contributor
too! lovely job.

I have some notepad files that contain data for me to plot. But thi
data seems to be too large for an excel spreadsheet. Is there anyway
could get around it.

My data is usuaally stored in a notepad file. This .txt file consist
of two columns for the X and Y data points. However the file has outpu
from several experiments. let me show you what my text file contains .

*notepad file*

Main Title = one cyc fullsystem.wmd, Amplitude vs Frequency
X Title = Frequency (MHz)
Y Title = Amp.
Legend = T - Rx3.1
0 0.000101
0.00823049 0.000305
0.016461 0.000175
0.0246915 0.000244
0.032922 0.000278
0.0411525 0.000141
0.0493829 0.000122
0.0576134 0.000460
0.0658439 0.000674
 
Hi:
I don't understand what you mean by "too large". Do you meen to large to
fit into a cell?
Anyway, a text file can be imported into Excel format. Go to the menu
Data/Import External Data/Import Data... and select the appropriate format.
The rest is automatic I gather.
GL,
Henk
 
Sorry Henk for not being clear. What I meant was the number of data
points is larger than the number of rows in the worksheet. Hence I keep
getting an error message saying that data will be lost.

I hope that clears my question a bit.

Thanks
 
Sorry Henk for not being clear. What I meant was the number of data
points is larger than the number of rows in the worksheet. Hence I keep
getting an error message saying that data will be lost.

I hope that clears my question a bit.
Click to expand...


Please say how many data points you have in your Notes file. Excel
should, if I'm not mistaken, be able to handle up to 65535 lines. Do you
have more lines than this or fewer?
 
Yes I have abt 100,000 or perhaps more. So it doesn't fit the
spreadsheet as it is. Any way I can get around this one?
 
dharshanie said:
Yes I have abt 100,000 or perhaps more. So it doesn't fit the
spreadsheet as it is. Any way I can get around this one?
Click to expand...

In which case, go into your raw data file, cut it into a number of separate
series to put into Excel, either in parallel columns on the same sheet or on
separate sheets, and plot them together on one chart. [You can always
format the different series the same so that they don't look like separate
series.]
 
Thanks for the reply. I have abt 100 files like this which need to be
transported and plotted. Is there a less time consuming way of doing
this? Is there a similar forum like this for Matlab anyone knows of?
 
Back
Top