Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2009

[Date Index] [Thread Index] [Author Index]

Search the Archive

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

> 




  • 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