BookmarkSubscribe
Choose Language Hide Translation Bar
rj69
Community Trekker

How can I combine some of the separate bars in a graph into one bar?

I have a simple bar chart, per below (# of promos is X-axis, # of views is Y-axis). In JMP 11, what would be the easiest way to combine some of the bars so that in the graph I can see the average views for 0 promos, 1 promo, 2 promos, and 3+ promos? Thanks.

12690_pastedImage_1.png

0 Kudos
6 REPLIES 6
Jeff_Perkinson
Community Manager Community Manager

Re: How can I combine some of the separate bars in a graph into one bar?

The fastest way is to create a new column using Cols -> Recode to combine the levels. Then use this new column in your graph.

-Jeff

-Jeff
0 Kudos
rj69
Community Trekker

Re: How can I combine some of the separate bars in a graph into one bar?

Thanks for the quick response, Jeff - but nothing seems to happen when I recode:

12692_pastedImage_1.png

Nothing happens when I try changing the values in the "new value" area and clicking OK. Not sure what I'm missing here, whether I'm inputting incorrect data into the "New Value" box or if I'm supposed to select a formula column (tried but didn't have luck with that, either) but it should be pretty simple.

0 Kudos
Jeff_Perkinson
Community Manager Community Manager

Re: How can I combine some of the separate bars in a graph into one bar?

Sorry about that. I forgot that Recode doesn't really like to work with Numeric columns. Change the Data Type of your # of promos column to Character and then try. Then do it to a New Column.

Let us know if still have trouble.

12693_JMPScreenSnapz043.png

-Jeff
rj69
Community Trekker

Re: How can I combine some of the separate bars in a graph into one bar?

Ah, good to know. The solution worked perfectly. Thanks Jeff!

0 Kudos

Re: How can I combine some of the separate bars in a graph into one bar?

Another option might be to use Col > Utilities > Make Binning Formula.  Or the interactive binning formula add-in (https://community.jmp.com/docs/DOC-6237)  And then using the binning formula column that is generated in your graph. 

best,

M

rj69
Community Trekker

Re: How can I combine some of the separate bars in a graph into one bar?

Thanks for the alternate solution!

0 Kudos