topic Re: side by side bar graph with 2 y in Discussions

side by side bar graph with 2 y

eranse — Wed, 15 Apr 2020 07:25:30 GMT

Hi,

I am trying to create a bar graph with 2 y axis. but whenever i move a column to the right to create the second axis - the bars become almost nested and I can't separate them.

I would like the bars to be separate as in the first graph but with the 2 different axis.

Seems like something very basic that I am missing -what is it?

Thanks,

Eran

Re: side by side bar graph with 2 y

Thierry_S — Wed, 15 Apr 2020 13:44:44 GMT

Hi Eran,
It seems to be a glitch: I'm working with JMP 14.1 and I too cannot figure out how to restore the proper bar lineup with 1 or 2 variables on the Left Y axis and 1 variable on the Right Y axis. Maybe a more seasoned JMP user could provide a suggestion

Re: side by side bar graph with 2 y

eranse — Wed, 15 Apr 2020 14:48:56 GMT

Hi Thierry,
I thought that in a previous JMP14 version it did work - and only recently encountered this when I tried to do it in the current Jmp15.1.0
I guess it is a glitch and hope it's fixed soon.
Eran

Re: side by side bar graph with 2 y

Thierry_S — Wed, 15 Apr 2020 15:12:51 GMT

Hi Eran,

I just checked the same graph options in JMP 13.1 and I have same problem

Best,

TS

Re: side by side bar graph with 2 y

gzmorgan0 — Wed, 15 Apr 2020 16:50:03 GMT

Hi @eranse ,

I am guessing you want a second axis because the magnitude of Column 3 is so much larger that Columns 2 and 4. However, in my opinion, a two axis bar chart is fraught with the risk of misinterpretation: a bar with a value of 90 next to a bar with about the same height and a value 340 is jarring. I think two axis plots can be useful to show data trends with lines, and even then only if the axes are colored to match the curves, etc.

Since the GraphBuilder platform is not producing what you need, I am suggesting an alternative plot

Graph Builder(
	Size( 763, 517 ),
	Show Control Panel( 0 ),
	Graph Spacing( 10 ),
	Variables( X( :Column 1 ), Y( :Column 4 ), Y( :Column 2 ), Y( :Column 3 ) ),
	Elements(
		Position( 1, 1 ),
		Bar( X, Y, Legend( 9 ), Label( "Label by Value" ) )
	),
	Elements(
		Position( 1, 2 ),
		Bar( X, Y, Legend( 8 ), Label( "Label by Value" ) )
	),
	Elements(
		Position( 1, 3 ),
		Bar( X, Y, Legend( 7 ), Label( "Label by Value" ) )
	),
	SendToReport(
		Dispatch( {}, "Graph Builder", OutlineBox, {Select} ),
		Dispatch( {}, "Column 4", ScaleBox, {Label Row( Show Major Grid( 1 ) )} ),
		Dispatch( {}, "Column 2", ScaleBox, {Label Row( Show Major Grid( 1 ) )} ),
		Dispatch( {}, "Column 3", ScaleBox, {Label Row( Show Major Grid( 1 ) )} ),
		Dispatch(
			{},
			"Y title",
			TextEditBox,
			{Set Font Size( 12 ), Set Font Style( "Bold" ), Font Color( 53 )}
		),
		Dispatch(
			{},
			"Y 1 title",
			TextEditBox,
			{Set Font Size( 12 ), Set Font Style( "Bold" ), Font Color( 19 )}
		),
		Dispatch(
			{},
			"Y 2 title",
			TextEditBox,
			{Set Font Size( 12 ), Set Font Style( "Bold" ), Font Color( 20 )}
		),
		Dispatch(
			{},
			"400",
			LegendBox,
			{Legend Position( {9, [1], 8, [0], 7, [2]} ), Position( {1, 0, 2} )}
		)
	)
)

However, I can create the graph you want (that I do not like). It requires restructuring your data. See the attached journal that creates the data table and this graph.

"Just because you can, doesn't mean you should."

Re: side by side bar graph with 2 y

eranse — Thu, 16 Apr 2020 05:24:03 GMT

Thanks,

I understand the potential problem with a graph with different y scales, but it is helpful to show the direction of the data, and I am not certain that placing the information on different graphs is always better.

Thank you for the solution - it does solve it perfectly.

Best,

Eran