Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- Box Plot Axis Problem

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 16, 2019 7:44 AM
(600 views)

I've long used JMP to make box plots to show the distributin of data for a number of field sites on the same axis. I recently upgraded to JMP 14 and now the axis look different than they have in the past. Specifically, I'm running into an issue where the axis seems homogenized regardless of where the actual outliers are. For instance, in the old format if the outlier was 20000 then it would plot 4x higher than an outlier for a different site with a max outlier of 5000. To minimize these, we use a log axis and it looks something like this:

However, in the new version, the top of the y-axis is the same for every dataset even if they are very different. Instead, the outermost datapoint simply has a label on it. It goes without saying that this signifficantly impacts where the median would appear to be. Further, since all the sites don't have the same axis, there aren't actually labels on the y-axis which makes the whole thing somewhat pointless. Here is what that looks like:

Things I've tried without sucess:

1) changing modeling type from continuous to ordinal

2) editing all sorts of axis settings. In fact, the one that I understand the least is the fact that the maxium on th scale is set to 1.02 even though there is a ton of data above that number. That seems to indicate that the axis is auto-scaled but I can't figure out how to change it. Well, I can change it but it doesn't seem to help. Here is what the settings look like:

Thanks for any and all help!

Brad

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Please try what I suggested. Tables > Stack. Select the 16 data columns and click Stack. Enter the name of the data in the Data Column. Enter Site for the Label Column.

Now you should be able to use the data column for Y and the label column for X. The scaling issue should not occur.

Learn it once, use it forever!

6 REPLIES 6

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Box Plot Axis Problem

The first example has a single column with many levels. It is a single Y. In the second example, you plotted 16 columns on the X axis. Try stacking the 16 columns and use the new lable column in the X role as before.

Learn it once, use it forever!

Highlighted
##

I somewhat see what you mean but the first one was always from multiple columns as well. I just didn't bother to rename the columns in the second one because I've been rebuilding it so often to see if I could get it to work. This data has always been organized with a column for each site and there isn't an easy way to reformat it because it doesn't have a column that identifies which site each datapoint is related to.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Box Plot Axis Problem

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Please try what I suggested. Tables > Stack. Select the 16 data columns and click Stack. Enter the name of the data in the Data Column. Enter Site for the Label Column.

Now you should be able to use the data column for Y and the label column for X. The scaling issue should not occur.

Learn it once, use it forever!

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Box Plot Axis Problem

I am using Big Class as the example. Here is the result when I stack four numeric data columns:

Here is the same data plotted as the original separate (un-stacked) columns:

Can you see the parallels between these results and the two of your own posted at the beginning?

Learn it once, use it forever!

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Box Plot Axis Problem

Thanks for the detailed steps. I'll give it a try.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Box Plot Axis Problem

Thanks for your help. That seems to work well. I'm a bit confused as to why it has changed through time becaues it used to work the other way (I've certainly never used the stack feature). Nonetheless, I'm happy to have a solution.

Thanks,

Brad

Article Labels

There are no labels assigned to this post.