topic Re: Two Y-axes, bar chart: How to display bars next to each other? in Discussions

Two Y-axes, bar chart: How to display bars next to each other?

ScaleMapsBear51 — Tue, 27 Feb 2024 09:19:46 GMT

Hi!

I am once again desperate with jmp, because I cannot set an actually simple display format. I want to create a bar chart with two Y-axes and display the bars per column next to each other and not on top of each other.

Thanks in advance!

Re: Two Y-axes, bar chart: How to display bars next to each other?

txnelson — Tue, 27 Feb 2024 10:49:39 GMT

How I created the graph you want requires modifications to the data table.

Create a second copy of the data table.
For the original data table
1. Create a new character column named "Group"
2. Set each value for the Group column to the name of the column that is to be used for the left axis
3. Delete the column that is to be used for the right axis
For the second copy of the data
1. Create a new character column named "Group"
2. Set each value for the Group column to the name of the column that is to be used for the right axis
3. Delete the column that is to be used for the left axis
Concatenate the two data tables together
Open Graph Builder
1. Drag the column to be used as the X axis to the X axis
2. Drag the two response columns to the Y axis
3. Right click on the Y Axis and select Move Right and move the appropriate column to the right axis
4. Drag the Group column to the Overlay Drop zone

This should give you the desired results.

Re: Two Y-axes, bar chart: How to display bars next to each other?

dlehman1 — Tue, 27 Feb 2024 11:57:14 GMT

It wasn't clear to me, but I understood the question to be more basic - how to get a dual axes graph. If that is all that is being asked, you get that by dragging both variables into the Y zone in Graph Builder and right clicking on the Y axes and using the Move Right option to create the second axes scale. I always have to look that up - it took me years to remember how to do it in Excel and I still don't recall it easily in JMP. I would say, however, that the utility of such graphs is limited - there is almost always a better display (dragging the two variables one at a time onto the Y axes so that one graph is above the other is usually a better display).