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

Large amount of data for plotting
 

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

Large amount of data for plotting
 

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


--
dharshanie
------------------------------------------------------------------------
dharshanie's Profile: http://www.excelforum.com/member.php...o&userid=23673
View this thread: http://www.excelforum.com/showthread...hreadid=544656

Large amount of data for plotting
 

On Tue, 23 May 2006, in microsoft.public.excel.charting,
dharshanie
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 ,
which goes to a spam folder-- please send your email to del3 instead.

Large amount of data for plotting
 

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
------------------------------------------------------------------------
dharshanie's Profile: http://www.excelforum.com/member.php...o&userid=23673
View this thread: http://www.excelforum.com/showthread...hreadid=544656

Large amount of data for plotting
 

"dharshanie" wrote
in message ...

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

Large amount of data for plotting
 

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
------------------------------------------------------------------------
dharshanie's Profile: http://www.excelforum.com/member.php...o&userid=23673
View this thread: http://www.excelforum.com/showthread...hreadid=544656

Large amount of data for plotting
 

"dharshanie" wrote
in message ...

... Is there a similar forum like this for Matlab anyone knows of?

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