cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-493934%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%E5%85%B7%E6%9C%89%E5%A4%9A%E5%80%8B%20XY%20%E5%B0%8D%E7%9A%84%E6%95%A3%E4%BD%88%E5%9C%96%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-493934%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%E4%BD%A0%E5%A5%BD%EF%BC%8C%E6%88%91%E5%B0%8D%20jmp%20%E9%82%84%E5%BE%88%E9%99%8C%E7%94%9F%EF%BC%8C%E5%B8%8C%E6%9C%9B%E6%88%91%E8%83%BD%E6%89%BE%E5%88%B0%E6%AD%A3%E7%A2%BA%E7%9A%84%E6%96%B9%E5%90%91%E3%80%82%E6%88%91%E6%AD%A3%E5%9C%A8%E4%BD%BF%E7%94%A8%20JMP%2015.2%E3%80%82%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E7%9B%AE%E5%89%8D%EF%BC%8C%E6%88%91%E5%B7%B2%E7%B6%93%E8%A3%BD%E4%BD%9C%E4%BA%86%E4%B8%80%E5%80%8B%E8%A1%A8%E6%A0%BC%EF%BC%8C%E7%94%A8%E6%96%BC%E5%BE%9E%E7%B7%A8%E8%AD%AF%E7%9A%84%E8%B3%87%E6%96%99%E9%9B%86%E4%B8%AD%E7%94%A2%E7%94%9F%E6%96%B0%E8%B3%87%E6%96%99%E3%80%82%E7%82%BA%E4%BA%86%E7%B0%A1%E5%8C%96%E9%80%99%E4%B8%80%E9%BB%9E%EF%BC%8C%E6%88%91%E6%9C%89%20A%E3%80%81B%E3%80%81C%20%E5%92%8C%20D%20%E5%88%97%E3%80%82%E5%9B%A0%E6%AD%A4%EF%BC%8C%E6%89%80%E6%9C%89%E8%A1%8C%E7%9A%84%20XY%20%E9%85%8D%E5%B0%8D%E6%87%89%E7%82%BA%203-B%E3%80%815-C%20%E5%92%8C%2010-D%E3%80%82%E6%88%91%E4%B8%80%E7%9B%B4%E5%9C%A8%E5%98%97%E8%A9%A6%E6%B7%BB%E5%8A%A0%E5%88%97%20E%E3%80%81F%20%E5%92%8C%20G%EF%BC%8C%E4%B8%A6%E7%82%BA%E6%AF%8F%E5%80%8B%E5%88%97%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E8%A1%8C%E5%88%86%E9%85%8D%E5%96%AE%E7%8D%A8%E7%9A%84%20X%20%E5%80%BC%E3%80%82%E6%89%80%E4%BB%A5%E5%88%97%E9%97%9C%E8%81%AF%E6%98%AFEB%E3%80%81FC%E3%80%81GD%E3%80%82%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E6%9C%89%E6%B2%92%E6%9C%89%E8%BE%A6%E6%B3%95%E5%83%8F%E9%80%99%E6%A8%A3%E5%B0%87%E8%B3%87%E6%96%99%E5%88%97%E5%96%AE%E7%8D%A8%E5%88%86%E7%B5%84%E4%B8%A6%E5%9C%A8%E6%95%A3%E4%BD%88%E5%9C%96%E4%B8%8A%E7%B9%AA%E8%A3%BD%E4%B8%8D%E5%90%8C%E7%9A%84%E7%B3%BB%E5%88%97%EF%BC%9F%E6%88%91%E5%98%97%E8%A9%A6%E5%A0%86%E7%96%8A%E6%95%B8%E6%93%9A%EF%BC%8C%E4%BD%86%E9%80%99%E5%8F%AA%E6%98%AF%E4%BD%BF%E5%85%A9%E5%88%97%E5%9C%A8%E5%90%8C%E4%B8%80%E5%88%97%E4%B8%AD%E5%90%8C%E6%99%82%E5%85%B7%E6%9C%89%20X%20%E5%92%8C%20Y%20%E5%80%BC%E3%80%82%E5%9B%A0%E6%AD%A4%EF%BC%8C%E7%94%A2%E7%94%9F%E7%9A%84%E5%9C%96%E5%B0%87%E5%8C%85%E5%90%AB%20Y%20%E5%80%BC%EF%BC%8C%E9%80%99%E4%BA%9B%E5%80%BC%E6%AD%A3%E6%98%AF%E5%85%B6%E5%B0%8D%E6%87%89%E7%9A%84%20x%20%E5%80%BC%E3%80%82%E5%9C%A8%20Excel%20%E4%B8%AD%E5%81%9A%E6%88%91%E8%AB%8B%E6%B1%82%E5%B9%AB%E5%8A%A9%E7%9A%84%E4%BA%8B%E6%83%85%E5%BE%88%E5%AE%B9%E6%98%93%EF%BC%8C%E5%9B%A0%E7%82%BA%E6%AF%8F%E5%80%8B%20X%20%E5%88%97%E9%83%BD%E5%8F%AF%E4%BB%A5%E7%9B%B4%E6%8E%A5%E8%88%87%20Y%20%E5%88%97%E7%9B%B8%E9%97%9C%EF%BC%8C%E4%BD%86%E6%88%91%E8%A9%A6%E5%9C%96%E5%9C%A8%E6%95%B8%E5%8D%83%E6%AC%A1%E6%B8%AC%E8%A9%A6%E4%B8%AD%E8%87%AA%E5%8B%95%E5%9F%B7%E8%A1%8C%E6%AD%A4%E5%88%86%E6%9E%90%E3%80%82%E4%BB%BB%E4%BD%95%E5%B9%AB%E5%8A%A9%EF%BC%8C%E5%B0%87%E4%B8%8D%E5%8B%9D%E6%84%9F%E6%BF%80%E3%80%82%E8%AC%9D%E8%AC%9D%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Example%20Table.png%22%20style%3D%22width%3A%20471px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Example%20Table.png%22%20style%3D%22width%3A%20471px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Example%20Table.png%22%20style%3D%22width%3A%20471px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42746i148A1C7DF1B16EAB%2Fimage-dimensions%2F471x175%3Fv%3Dv2%22%20width%3D%22471%22%20height%3D%22175%22%20role%3D%22button%22%20title%3D%22Example%20Table.png%22%20alt%3D%22Example%20Table.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22AdditiveHippo74_0-1653613132391.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22AdditiveHippo74_0-1653613132391.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22AdditiveHippo74_0-1653613132391.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42745iB2B70D2AAF5A6CBF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22AdditiveHippo74_0-1653613132391.png%22%20alt%3D%22AdditiveHippo74_0-1653613132391.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-493934%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3E%E5%93%81%E8%B3%AA%E5%92%8C%E5%B7%A5%E8%97%9D%E5%B7%A5%E7%A8%8B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-493997%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%85%B7%E6%9C%89%E5%A4%9A%E5%80%8B%20XY%20%E5%B0%8D%E7%9A%84%E6%95%A3%E9%BB%9E%E5%9C%96%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-493997%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%89%80%E9%9C%80%E8%A6%81%E5%81%9A%E7%9A%84%E5%B0%B1%E6%98%AF%E5%B0%8D%E6%95%B8%E6%93%9A%E9%80%B2%E8%A1%8C%E5%A4%9A%E6%AC%A1%20Seares%20Stack%EF%BC%8C%3C%2FP%3E%0A%3CP%3E%E8%A1%A8%3D%26gt%3B%E5%A0%86%E6%A3%A7%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22txnelson_0-1653615723704.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1653615723704.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1653615723704.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1653615723704.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1653615723704.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42750i6464A72FAA2612B2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22txnelson_0-1653615723704.png%22%20alt%3D%22txnelson_0-1653615723704.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E7%84%B6%E5%BE%8C%E4%BD%BF%E7%94%A8%E7%94%9F%E6%88%90%E7%9A%84%E6%95%B8%E6%93%9A%E8%A1%A8%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22txnelson_1-1653615799926.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_1-1653615799926.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_1-1653615799926.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_1-1653615799926.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_1-1653615799926.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42751i42255EF3EF528DC8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22txnelson_1-1653615799926.png%22%20alt%3D%22txnelson_1-1653615799926.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E6%82%A8%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%E5%9C%96%E8%A1%A8%E7%94%9F%E6%88%90%E5%99%A8%E5%B0%87%E5%88%97%20Data%202%20%E6%94%BE%E5%9C%A8%20Y%20%E8%BB%B8%E4%B8%8A%EF%BC%8C%E5%B0%87%E5%88%97%20Data%20%E6%94%BE%E5%9C%A8%20Y%20%E8%BB%B8%E4%B8%8A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22txnelson_2-1653615919193.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_2-1653615919193.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_2-1653615919193.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_2-1653615919193.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_2-1653615919193.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F42752i9E671D70B4BFF474%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22txnelson_2-1653615919193.png%22%20alt%3D%22txnelson_2-1653615919193.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-494002%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%85%B7%E6%9C%89%E5%A4%9A%E5%80%8B%20XY%20%E5%B0%8D%E7%9A%84%E6%95%A3%E4%BD%88%E5%9C%96%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-494002%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E8%AC%9D%E8%AC%9D%E5%90%89%E5%A7%86%E3%80%82%E7%95%B6%E6%88%91%E5%98%97%E8%A9%A6%E6%99%82%EF%BC%8C%E6%88%91%E8%AA%A4%E8%A7%A3%E4%BA%86%E5%A4%9A%E5%80%8B%E5%A0%86%E7%96%8A%E7%99%BC%E7%94%9F%E7%9A%84%E6%83%85%E6%B3%81%E3%80%82%E7%8F%BE%E5%9C%A8%E9%96%8B%E5%A7%8B%E5%9C%A8%E7%A8%8B%E5%BC%8F%E7%A2%BC%E4%B8%AD%E5%AF%A6%E9%9A%9B%E7%94%A2%E7%94%9F%E6%89%80%E6%9C%89%E7%B9%AA%E5%9C%96%E3%80%82%E9%9D%9E%E5%B8%B8%E6%84%9F%E8%AC%9D%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Scatter Plot With Multiple XY pairs

Hi, I am pretty new to jmp and was hoping I could get pointed in the right direction. I am using JMP 15.2.

 

Currently, I have make a table where I generate new data from a compiled dataset.  To simplify this, I have column A, B, C and D.  Column A generates the values in B, C, and D.  There is a single X value for each column (for now say 3, 5, and 10).  So the X-Y pairing should be 3-B, 5-C and 10-D for all rows.  What I have been trying is adding columns E, F and G and assign all rows in each column with the individual X value.  So the column association is E-B, F-C, and G-D.

 

Is there a way to group data columns individually like this and plot the different series on a scatter plot?  I attempted to stack the data, but this was just making both columns have both the X and Y value in the same column.  The resulting plots would thus contain Y values which were just their corresponding x value.  Doing what I am asking help on is easy in excel as each X column can be directly correlated to a Y column, but I am trying to automate this analysis over thousands of tests.  Any help would be appreciated.  Thank You

 

Example Table.png

 

AdditiveHippo74_0-1653613132391.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Scatter Plot With Multiple XY pairs

All that is required is to do a Multiple Seares Stack on the data,

     Tables=>Stack

txnelson_0-1653615723704.png

Then using the resulting data table

txnelson_1-1653615799926.png

you can use Chart Builder to place column Data 2 on the Y axis and column Data on the Y axis

txnelson_2-1653615919193.png

 

 

 

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: Scatter Plot With Multiple XY pairs

All that is required is to do a Multiple Seares Stack on the data,

     Tables=>Stack

txnelson_0-1653615723704.png

Then using the resulting data table

txnelson_1-1653615799926.png

you can use Chart Builder to place column Data 2 on the Y axis and column Data on the Y axis

txnelson_2-1653615919193.png

 

 

 

Jim

Re: Scatter Plot With Multiple XY pairs

Thank you Jim. I misunderstood what happened with the multiple stacks when I was attempting it.  On to actually producing all of the plots in code now.  Much appreciated.

Recommended Articles