cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
lilywhitmoyer
New Member

How do I reorder the data categories in the bars to match the legend?

I want the data displayed to be in numerical order with <0.5 at the bottom. I found an old post about this but it's outdated so the feature isn't available anymore.

lilywhitmoyer_0-1721949206010.png

4 REPLIES 4
txnelson
Super User

Re: How do I reorder the data categories in the bars to match the legend?

Set the Value Order column property for the Particle Size column.

Right click on the column header for Particle Size and select 

     Column Property=>Value Order

Change the order of the values by selecting each and using the up and down arrows, move the value to the place in the order you want it to be.

Jim
hogi
Level XI

Re: How do I reorder the data categories in the bars to match the legend?

Won't this affect the legend as well?

I don't know who decided to use in bar chart and legend the opposite order !?!?

Is this just JMP or a wordwide standard?

 

Sure, a user can double click the legend and adjust the order.

But unfortunately, there is no "reverse order" function. Just imagine that you have 20 entries - or 100!

jthi
Super User

Re: How do I reorder the data categories in the bars to match the legend?

You can force JMP to workaround the reverse ordering by adding value order to your overlay column, duplicating overlay column, setting it to have reversed value order and using that as color (or do it by reordering like Jim suggested)

jthi_1-1721990697288.png

With the double column

jthi_2-1721990708196.png

Data table attached.

-Jarmo
hogi
Level XI

Re: How do I reorder the data categories in the bars to match the legend?

Hm, I have yet to decide whether this shows how flexible JMP is - or how much effort it takes to make it easier for the audience to understand the graph. Most users will decide that the "wrong" order is not sooo bad : )

 

A reverse order button in the legend menu could provide an elegant shortcut.

And just imagine how useful  revert to default could be ...
Wish list - new Label: user experience 

hogi_0-1721992380428.png