topic Re: HI Re: graph Builder with several X lines in Discussions

graph Builder with several X lines

TalDamri — Sun, 11 Jun 2023 11:08:50 GMT

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 ?

Re: graph Builder with several X lines

Mark_Bailey — Wed, 09 Dec 2020 10:59:24 GMT

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

txnelson — Wed, 09 Dec 2020 11:05:48 GMT

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 lines

TalDamri — Sun, 13 Dec 2020 09:44:16 GMT

Hi,

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.

Re: graph Builder with several X lines

txnelson — Sun, 13 Dec 2020 12:45:22 GMT

Would it be possible for you to attach a sample of your actual input data file?

Re: graph Builder with several X lines

TalDamri — Sun, 13 Dec 2020 13:13:15 GMT

mm..

un fortunately this is impossible, the Work network is disconnected form the global Internet.

Re: graph Builder with several X lines

txnelson — Sun, 13 Dec 2020 14:21:59 GMT

OK, so let's start with the basic format of your Excel table. From the data provided in your previous response, is this what your Excel table looks like?

or does your Excel table look like this?

HI Re: graph Builder with several X lines

TalDamri — Mon, 14 Dec 2020 09:40:44 GMT

Hi,

It take time, but I I finally succeeded to uplode the excel file.

attached.

Thanks for all the help

Re: HI Re: graph Builder with several X lines

txnelson — Mon, 14 Dec 2020 12:00:08 GMT

Thank you for the Excel file. It makes the task an easy one.

Go to

File=>Open

In the Open dialog box

Navigate to the folder that has the Excel file.

Select to read in xlsx files

Click on the Excel file

Specify to use the JMP Excel Wizard to help to open the file

In the JMP Excel Wizard window,

Specify 3 as the Number of rows with column headers

Specify 4 as the Data starts on row

Click on Import

The data table will open and it will look like

Open the Graph Builder platform by clicking on the Graph Builder Icon on the icon bar at the top of the window

In the Graph Builder window

Drag the column D-Time to the X axis drop area. The D-Time column is selected, since it contains all of the values for the Times

Select all of the Temperature columns, and drag them to the Y axis drop area

Click on the Line Chart Icon at the top of the window

You will now have a screen that looks like

You need to take the time to read the Discovering JMP and the Essential Graphing documents from the JMP Documentation Library under the Help pull down menu

Re: HI Re: graph Builder with several X lines

TalDamri — Mon, 14 Dec 2020 12:40:16 GMT

HI,

This is really detailed solution. Thanks.

One more question for future cases:

If the time columns is not with the same frequency (e.g. , "Time 1 "frequency is 1 sec, and "Time 2 " frequency is two seconds per row. ) is it possible to plot all the "time - temp" series on the same graph ?

Thank for the advice about the documentation, I will take time to read it.

Re: HI Re: graph Builder with several X lines

txnelson — Mon, 14 Dec 2020 13:45:04 GMT

The better way to handle it would be to use

Tables=>Stack

and do a multi series stack, and then go from there