Subscribe Bookmark RSS Feed

[Help] Box plot from data not x-y paired

smokefly

Community Trekker

Joined:

Jan 23, 2016

I probably have a very newbie question on creating box plot. Actually I've use JMP for data analysis for several years. My application is quite simple. We have different conditions and we compare the results. What I have been doing is I always had data file of x-y pair. For example, x column is several conditions and y column is the data. From that data format, I can create box plot easily by either Graph Builder, or Fit Y by X, or variability chart.

Today I had a data file which are just columns of result data. Condition is put in the column header. I could get box plot in Graph Builder, but the condition is shown on the side as legends, and I would like to have conditions on the x-axis. I'm wondering if there is any way to do that? Otherwise, I will have to copy past all data into one single column and create the corresponding x-column filled with conditions. It will be messy when I have bunch of different conditions.

An example in the picture below. Column 1 and 2 are what I am facing. Column 3 and 4 are my old way of plotting.

10791_Screen Shot 2016-01-23 at 12.43.32 AM.png

Here is what I can get from column 3+4.

10792_Screen Shot 2016-01-23 at 12.45.10 AM.png

Here is from column 1+2, which shows legends on right hand side instead of on x-axis.

10802_Screen Shot 2016-01-23 at 12.47.54 AM.png

Thanks in advance for any comments/help.

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Hello,

If I understand correctly you would like to transform your data from an X and Y column to a stacked format.

You can do this by using the stack command from the tables menu.

Tables-->Stack

10801_Screen Shot 2016-01-23 at 5.20.05 PM.png

When the menu opens enter the options as shown:

10805_Screen Shot 2016-01-23 at 5.20.18 PM.png

Select your x and y columns and add to the Stack columns.

Change the data column to value.

Change the label column to axis.

Unselect the stack by row option.

Click ok.

This will produce a new table with the axis and values stacked as shown below.

10806_Screen Shot 2016-01-23 at 5.20.29 PM.png

You can right-click on the attached table script and select run to reproduce.

Cheers,

Stan

2 REPLIES
Solution

Hello,

If I understand correctly you would like to transform your data from an X and Y column to a stacked format.

You can do this by using the stack command from the tables menu.

Tables-->Stack

10801_Screen Shot 2016-01-23 at 5.20.05 PM.png

When the menu opens enter the options as shown:

10805_Screen Shot 2016-01-23 at 5.20.18 PM.png

Select your x and y columns and add to the Stack columns.

Change the data column to value.

Change the label column to axis.

Unselect the stack by row option.

Click ok.

This will produce a new table with the axis and values stacked as shown below.

10806_Screen Shot 2016-01-23 at 5.20.29 PM.png

You can right-click on the attached table script and select run to reproduce.

Cheers,

Stan

smokefly

Community Trekker

Joined:

Jan 23, 2016

Hi Stan, thanks for the help. I thought there could be a way to plot directly. But stacking data works too.