       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"] []]

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[], #}] & /@ 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

>

```

• Prev by Date: Which editor do you use for math articles
• Next by Date: Re: Mathematica and Access
• Previous by thread: Re: Plot Lists of values from excel to mathematica
• Next by thread: Re: Plot Lists of values from excel to mathematica