Stacked and Side by side bar chart in one graph

Chris_Kirchberg

Hi SE Community,

I am stuck with trying to get the attached graph made in Excel to be made in Graph Builder without scripting

There is a PSA test (y-axis) that comes as two columns (two versions of the same test) that should be staked in a bar and then a different related test (PET) that should be displayed on the side of that PSA test for that person (x-axis). Notice that bar labelled D21 has both PSA tests stacked and a PET test next to it. 

I am having a tough time forcing Graph Builder to do this. Data comes in as tests and patient ID in as columns along with treatment in a column (cohorts colored red and blue).

I checked this post Mixed Stacked and Side-by-side Bar Graph in JMP - JMP User Community but it does not address the above issue.

Any ideas?

Thanks,

example data.jmp

brady_brady

Here is one way I could get close....

The data is quasi-stacked... PSA values are in a test 1 and test 1 + test 2 column, while PET is in a test 1 column with test 2 = 0. Overlay with a column for PET/PSA. Use 2 side-by-side bar elements, and use the Customize... menu to make the bars for test 1 show on top of the bars for test 1 + test 2. Adjust transparency less than 1 so that when the test 1 and test 1 + test 2 bars are on top of each other, it appears as a darker bar, giving the illusion of stacked bars.

What a mess, hope this helps.

Cheers,

Brady

 

Graph Builder(
	Size( 879, 716 ),
	Variables(
		X( :Column 1 ),
		Y( :test1 ),
		Y( :"test1+test2"n, Position( 1 ) ),
		Overlay( :Label )
	),
	Elements( Bar( X, Y( 1 ), Legend( 4 ) ), Bar( X, Y( 2 ), Legend( 6 ) ) ),
	SendToReport(
		Dispatch( {"Bar"}, "", OutlineBox, {Close( 0 )} ),
		Dispatch( {"Bar"[2]}, "", OutlineBox, {Close( 0 )} ),
		Dispatch(
			{},
			"Column 1",
			ScaleBox,
			{Min( -0.506533600240851 ), Max( 2.5205631739527 ), Inc( 1 ),
			Minor Ticks( 0 )}
		),
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				4,
				Properties( 0, {Transparency( 0.8 )}, Item ID( "PET", 1 ) ),
				Properties( 1, {Transparency( 0.5 )}, Item ID( "PSAs", 1 ) )
			), Legend Model(
				6,
				Base( 0, 0, 0, Item ID( "PET", 1 ) ),
				Properties( 0, {Transparency( 0.1 )}, Item ID( "PET", 1 ) )
			)}
		),
		Dispatch( {}, "Graph Builder", FrameBox, {Reorder Segs( {1, 2, 4} )} ),
		Dispatch(
			{},
			"400",
			LegendBox,
			{Legend Position( {4, [0, 2], 6, [1, -3]} )}
		)
	)
)