Turn on suggestions

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

Showing results for

- JMP User Community
- :
- Discussions
- :
- How can I combine some of the separate bars in a graph into one bar?

Topic Options

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

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

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

Sep 8, 2016 7:00 AM
(3313 views)

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.

6 REPLIES 6

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

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

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

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:

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.

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

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.

-Jeff

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

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!

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

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

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

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

Thanks for the alternate solution!