Heatmap not displaying cells with no data in Graph Builder

[#1]

Editor's Note: This topic was moved from a comment inBordered or Higher Contrast Heatmap in Graph Builder . Please refer to this Wish List item for context.

Hi all,

I'd like to come back to this topic. I am trying to create a similar heatmap, but the cells that don't have values don't get a border, as you can also see in the example of Paul (row DH). Any suggestion how this can be achieved?

I'm using the heatmap to build a kind of wafer map that has 21 zones. I would like to border all the zones, but the problem is that for some zones there is no data. I already tried to fill in 0, but then it messes with the color gradient.

Looking forward to your reply.

[#2]

Here is how it looks like, but due to entering 0 the colors of the actual datapoints are impacted. And if I don't put 0, the cells without data are not bordered:

[#3 · Accepted solution]

What color would you like the cells with no values to be, I'm guessing white?  If so you could add gridlines to the axis and add the heatmap line color, then you should see every thing filled in:

Here is a script to recreate these values:

Names default to here(1);

dt = Open( "$Sample_data/big class.jmp" );

dt << Graph Builder(
	Size( 550, 482 ),
	Show Control Panel( 0 ),
	Variables( X( :height ), Y( :weight ) ),
	Elements( Heatmap( X, Y, Legend( 4 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"height",
			ScaleBox,
			{Label Row(
				{Major Grid Line Color( 0 ), Minor Grid Line Color( 0 ),
				Show Major Grid( 1 ), Show Minor Grid( 1 )}
			)}
		),
		Dispatch(
			{},
			"weight",
			ScaleBox,
			{Label Row(
				{Major Grid Line Color( 0 ), Minor Grid Line Color( 0 ),
				Show Major Grid( 1 ), Show Minor Grid( 1 )}
			)}
		),
		Dispatch(
			{},
			"Graph Builder",
			FrameBox,
			{DispatchSeg( RectSeg( 1 ), Line Width( 1 ) )}
		)
	)
)

[#4]

Hello ih,

Thanks for this suggestion, this is exactly what I'm looking for. However, for my case the grid lines are crossing the actual zones as you can see below:

Do you think there is a way to get the grid lines in between?

[#5 · Accepted solution]

I actually just found the solution myself... change automatic to long divider! thanks for the tip!