Re: Plot Lists of values from excel to mathematica
- To: mathgroup at smc.vnet.net
- Subject: [mg95356] Re: Plot Lists of values from excel to mathematica
- From: dh <dh at metrohm.com>
- Date: Fri, 16 Jan 2009 06:10:36 -0500 (EST)
- References: <gkn5it$igm$1@smc.vnet.net>
Hi Dino,
assume that your data is in file f.xls. Then we read the file, extract
the first table and transpose the data because we want to work with raws
not columns.
d = Transpose[Import["d:/tmp/t.xls", "Data"] [[1]]]
If your x values are 1,2,3.., this is the default and we my simply only
specify the y-values like in:
ListLinePlot[Rest[d]]
However, if you have arbitrary x values, we must add them to every raw
of y values:
d = Transpose[{d[[1]], #}] & /@ Rest[d];
ListLinePlot[d]
hope this helps, Daniel
dinodeblasio at gmail.com wrote:
> Hello everybody I'd like to plot in mathematica one four columns data
> that i have in excel, how i can do that in mathematica? For example I
> have:
> 1 5 2 4
> 2 6 1 2
> 3 2 2 1
> 4 1 7 2
>
> I'd like to have a plot wher on the x axis I have 1,2,3,4 and for the
> x=1 the point are at: 5,2,4; at x=2 the points are at 6,1,2 and so on.
> What is the simplest way to do that in mathematica?
> Thanks very much.
> Dino
>