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 >