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

Question

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.

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

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

Thanks in advance for any comments/help.

stan_koprowski · Accepted Answer

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

When the menu opens enter the options as shown:

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.

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

Cheers,

Stan