How to change all box plot confidence diamonds colors in graph builder?

mvanderaa1 — Sun, 11 Jun 2023 11:24:08 GMT

Hi, I want to have the confidence level color black for all my box plots in graph builder. See below example of the monthly sales datatable. I'm using the "Month" column as coloring variable, but my confidence diamonds are not visible as they have the same color as the box plots.

I tried to add a loop to set the line color to black, but this changes the box plot colors to gray

gb = Graph Builder(
	Size( 1805, 897 ),
	Show Control Panel( 0 ),
	Variables( X( :Month ), Y( :Sales ), Color( :Month ) ),
	Elements(
		Box Plot(
			X,
			Y,
			Legend( 9 ),
			Box Style( "Solid" ),
			Confidence Diamond( 1 ),
			Fences( 0 )
		)
	)
);
//tried the method of changing the confidence level line color to black for each box plot, 
//but it removes all pre-existing colors 
bpseg = gb << Xpath( "//BoxPlotSeg" );
bpseg << Line Color (0);

Attached is also the datatable, any help would be appreciated

Re: How to change all box plot confidence diamonds colors in graph builder?

txnelson — Thu, 25 Jul 2024 12:07:16 GMT

I was able to accomplish what you want by making a couple of changes to your approach.

Create your chart, but do not select Confidence Diamonds
Right click on the chart and select Add=>Box Plot, to add a second Box Plot
In the variables for the 2nd Box Plot, expand the section and unselect Color Month
Now Right Click on the chart and select the 2nd Box Plot and select Confidence Diamonds
Finally, go to the legend and Right Click the Sales and change the Line Color to black

Here is the script from the chart

Names Default To Here( 1 );
dt = Current Data Table();

Graph Builder(
	Variables( X( :Month ), Y( :Sales ), Color( :Month ) ),
	Elements(
		Box Plot( X, Y, Legend( 4 ), Box Style( "Solid" ), Fences( 0 ) ),
		Box Plot( X, Y, Color( 0 ), Legend( 5 ), Confidence Diamond( 1 ) )
	),
	SendToReport(
		Dispatch( {"Box Plot"[2]}, "", OutlineBox, {Close( 0 )} ),
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				5,
				Properties( 0, {Line Color( 0 )}, Item ID( "Sales", 1 ) )
			)}
		)
	)
);

topic Re: How to change all box plot confidence diamonds colors in graph builder? in Discussions

How to change all box plot confidence diamonds colors in graph builder?

Re: How to change all box plot confidence diamonds colors in graph builder?