cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
hchen
Level I

Can't Set Error Bars Using Overlaid Bar Graphs

Hello Everyone!

 

I've been struggling recently with setting standard deviation intervals on my bar graphs when I use the overlay function (in graph builder).  The script is attached below.  However, when I use the "color" function instead, I am able to insert my standard error intervals.  Does anyone know why this is happening?  Any inputs would be much appreciated

Graph Builder(
	Variables(
		X( :Condition ),
		Y( :VCaP % Recovery From Day 0 Avg ),
		Overlay( :Condition )
	),
	Elements(
		Bar(
			X,
			Y,
			Legend( 8 ),
			Error Interval( "Standard Deviation" ),
			Label( "Label by Value" )
		),
		Caption Box( X, Y, Legend( 9 ), Summary Statistic( "N" ) )
	),
	SendToReport(
		Dispatch(
			{},
			"VCaP % Recovery From Day 0 Avg",
			ScaleBox,
			{Min( 0.184582944951971 ), Max( 1.68175572067351 ), Inc( 0.2 ),
			Minor Ticks( 1 ), Add Ref Line( 1.25, "Dashed", "Black", "125%", 1 ),
			Add Ref Line( 0.7, "Dashed", "Black", "70%", 1 )}
		),
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				8,
				Properties( 0, {Fill Color( 10 )}, Item ID( "Standard", 1 ) ),
				Properties( 1, {Fill Color( 24 )}, Item ID( "Upside-down", 1 ) ),
				Properties( -1, {Fill Color( 10 )}, Item ID( "Mean", 1 ) ),
				Properties( -1, {Fill Color( 24 )}, Item ID( "Test", 1 ) )
			)}
		),
		Dispatch(
			{},
			"graph title",
			TextEditBox,
			{Set Text( "Mean VCaP % Recovery on Day 8" )}
		),
		Dispatch( {}, "Y title", TextEditBox, {Set Text( "VCaP % Recovery" )} )
	)
)
2 REPLIES 2
Thierry_S
Super User

Re: Can't Set Error Bars Using Overlaid Bar Graphs

Hi,
This might sound quite silly but does your data includes multiple point per Condition so that a Standard Deviation can actually be calculated?

Also, do you have have pre-calculated Standard Deviation values in the table. If it is the case, you should use the Standard Deviation column in the Interval drop zone on the right of the Graph Builder plot.

If possible, could you share an example of the data table (real or mock values) for which you are having issues?

Best,

TS
Thierry R. Sornasse
hchen
Level I

Re: Can't Set Error Bars Using Overlaid Bar Graphs

Hello Thierry,

 

Thank you for taking the time to help me with this. 

 

I've included a mock table containing the problem I'm describing taken from my data set with sensitive information removed.  The data set has an N of 24, and I have been relying on JMP software to calculate the STDev for me.  In this file,  I've also included in the table the difference when using "Condition" vs "Color" drop zones in this file if you don't mind taking a look.

 

Thank you again for taking the time to look at this with me.  Your help here is much appreciated.