Large amount of data for plotting

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

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

My data is usuaally stored in a notepad file. This .txt file consists of two columns for the X and Y data points. However the file has output 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
.
.
.

Legend = T - Rx3.2
0 0.000316
0.00823049 0.000425
0.016461 0.000181
0.0246915 0.000285
0.032922 0.000248
0.0411525 0.000148
.
.
.
Legend = T - Rx3.3
0 0.000004
0.00823049 0.000174
0.016461 0.000282
0.0246915 0.000142
0.032922 0.000289
0.0411525 0.000108
0.0493829 0.000244
0.0576134 0.000312

and so on

Each data set has quite a lot of data points and so I can't do a copy paste into excel for this reason.

So I was wondering if someone could tell me if I could import this data into excel using another method and then plot the data

Matlab came to my mind but I am very very new to MATlab and haven't found much help online on matlab either. Are there any matlab forums ?Or can excel do the job for me with some complicated method?


I would very much appreciate some help on this PLEASE PLEASE

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

"dharshanie" wrote:

>
> hi there! Thanks for this great forum and all you valuable contributors
> too! lovely job.
>
> I have some notepad files that contain data for me to plot. But this
> data seems to be too large for an excel spreadsheet. Is there anyway I
> could get around it.
>
> My data is usuaally stored in a notepad file. This .txt file consists
> of two columns for the X and Y data points. However the file has output
> 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
>

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

On Tue, 23 May 2006, in microsoft.public.excel.charting,
dharshanie <[email protected]>
said:

>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.


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?

--
Del Cotter
NB Personal replies to this post will send email to [email protected],
which goes to a spam folder-- please send your email to del3 instead.

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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?

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.]
--
David Biddulph

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?

"dharshanie" <[email protected]> wrote
in message news:[email protected]...
>
> ... Is there a similar forum like this for Matlab anyone knows of?

news:comp.soft-sys.matlab
--
David Biddulph