How do add different background colors to this drawing in JMP?

[#1]

Use the data from Big Class.jmp to draw pictures according to the following JSL,
The X-axis is grouped by age and compared according to the number of occurrences of each age and the average of the total number of ages
If the number of occurrences of this age is greater than the average, the background color of this age column is red;Otherwise it is green.

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
d2 = dt << Summary( Group( age ), Freq( "0" ), Weight( "0" ), Link to original data table( 0 ) );
Column( d2, 2 ) << set name( "co" );
s = Median( d2[0, 2] );
ca = "than";
New Column( ca );
Column( ca ) << Formula( co > s );
d2 << run formulas;
Column( ca ) << deleteFormula;
dt << Update( With( d2 ), Match Columns( age = age ), Add Columns from Update table( than ) );
p1 = dt << Graph Builder(
	Variables( X( :weight ), Y( :height ), Group X( :age ), Color( :sex ) ),
	Elements( Bar( X, Y, Legend( 5 ), Response Axis( "X" ) ) )
);

[#2]

This effect、Thanks!

[#3]

In addition, how to mark ① a place on the graph, how to write JSL so that the "Hover label" function of clicking there can obtain the name, height and other data of this graph position to write different variables

[#4]

One option is to create one additional column to your table which indicates the maximum value possible and then create a line chart using that with fill below enabled.

Column 7 has just value 70 in all rows

Graph Builder(
	Size(570, 798),
	Variables(
		X(:weight),
		Y(:height),
		Y(:Column 7, Position(1)),
		Group X(:age),
		Overlay(:than),
		Color(:sex)
	),
	Elements(
		Bar(X, Y(1), Legend(5), Response Axis("X")),
		Line(Y(2), Color(0), Legend(8), Fill("Fill Below"))
	),
	SendToReport(
		Dispatch({"Bar"}, "", OutlineBox, {Close(0)}),
		Dispatch({"Line"}, "", OutlineBox, {Close(0)}),
		Dispatch(
			{},
			"height",
			ScaleBox,
			{Min(0), Max(70.3382899628253), Inc(10), Minor Ticks(0)}
		),
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				8,
				Properties(0, {Line Color(35)}, Item ID("0", 1)),
				Properties(-1, {Line Color(35)}, Item ID("Mean(Column 7)", 1))
			)}
		)
	)
)

[#5]

Thanks Experts!

[#6]

• What are the specific steps of manual operation of this JSL?

Thank jthi !

[#7]

Create column with all values of 70, create graph builder with bar chart and line chart (x: weight, yaxis: height + column 7, overlay: than, color: sex) and modify line chart settings (fill to fill below), disable x axis from line chart, modify legend as needed. You should be able to track most of the changes just be checking out the graph builder and what has been set and where

[#8]

• How can I make both a bar chart and a line chart on the Y-axis?

Thanks!

[#9]

Right click on the graph, and select Add=>Line

[#10 · Accepted solution]

Thanks Experts!