340437_en-US

liliconcom

graph Builder with several X lines

Hi, 

 

I have an excel sheet, with several row series,

each series containing one row of "time [second],"  and one row of "temp" 

I would like to cmobine all the temp data to one graph, (one y axis - temp, and one x axis time) 

in excel it is very easy make that, but how i doing that in JMP ? 

 

 

Data TableGraphicsRe: graph Builder with several X lines

I suggest that you first read the documentation for Graph Builder in the Essential Graphing guide. The explanations and examples should make it clear how to organize your data in a JMP data table and how to cast your variables (data columns) in to the plotting roles.

Re: graph Builder with several X lines

JMP needs for the data to be in a different structure.  Your data looks like

But without the "Label" column.

An easy way to convert your data is to add a Label column, and give it the Values like displayed in the above data table.

Then go to the Tables pull down menu and select Transpose

     Tables=>Transpose

and specify all of the Col columns as the Transpose Columns, and the Label column as the Label

 

It will give you a table that looks like

Now you can go to Graph Builder and create the graph by dragging all of the selecting all of the Time columns and dragging them to the X drop area, and then selecting all of the Temp columns and dragging them to the Y drop area and then clicking on the Line Chart icon at the top of the window

Re: graph Builder with several X linesHi,



Thanks for the detailed answer,



It is very helpful!



If possible, more question about it. When I tried use it , the beginning of the data table look like this:




1142A-U-L2-09-Time-[s]

1142A-U-L2-09-Temperature-[°C]

1142A-U-L2-10-Time-[s]

1142A-U-L2-10-Temperature-[°C]

1.00

22.62169

1

28.8372

2.00

22.65976

2

28.8372

3.00

22.65976

3

28.41843

4.00

22.65976

4

28.41843

5.00

22.65976

5

28.07581

6.00

22.62169

6

28.07581




My question is how the graph builder know how to connect between the correct time and temperature ? is it due the similarity of columns names? or due the columns orders?



Thanks In advance.