topic Re: Can JMP draw this pattern? in Discussions

Can JMP draw this pattern?

lala — Fri, 09 Jun 2023 17:00:56 GMT

Hello!

Draw a horizontal bar chart of height data,
Graph the data on weight.
Superimpose two graphs on one graph.

Re: Can JMP draw this pattern?

jthi — Fri, 10 Jun 2022 14:45:17 GMT

I'm not exactly sure what type of graph you want to plot. You have two different Y-axis on same axis and x-axis which scales to some other values for other data.

You can for example plot something like this where you move other X-axis to other side:

Re: Can JMP draw this pattern?

ih — Fri, 10 Jun 2022 18:04:50 GMT

I know this isn't exactly what you asked for before but I frequently draw graphs similar to this, maybe this recording will give you some ideas on how to make something like what you are looking for:

(view in My Videos)

Re: Can JMP draw this pattern?

lala — Sat, 11 Jun 2022 00:22:26 GMT

Thank Jarmo!

That's exactly what I want.I want the red graph to be shorter on the X-axis.

Hope to get specific aspects, Thanks!

This kind of graph is easy to draw with Excel, and two data are made into different graphs respectively.Then set the background of one to transparent and overlay it on top of the other.

Re: Can JMP draw this pattern?

lala — Sat, 11 Jun 2022 00:27:57 GMT

Thank you very much!

I learned this method through videos and saw how adding rows can be done this way.

Re: Can JMP draw this pattern?

lala — Sat, 11 Jun 2022 01:35:10 GMT

excel

Re: Can JMP draw this pattern?

txnelson — Sat, 11 Jun 2022 03:26:08 GMT

Here is my attempt. It creates the needle chart transforming the Height and R values to match the range of the Weight and .25% of the r axis. The a FrameBox copy is done from one graph to the other;

names default to here(1);
// Open Data Table: big class.jmp
// → Data Table( "big class" )
dt = Open( "$SAMPLE_DATA/big class.jmp" );

dt << new column("r", set each value(Row()));

gb1 = dt << Graph Builder(invisible,
	Size( 528, 454 ),
	Show Control Panel( 0 ),
	Variables(
		X( Transform Column( "r 2", Formula( :r * 0.25 ) ) ),
		Y(
			Transform Column(
				"height 2",
				Formula(
					If( Row() == 1,
						ytargetmax = Col Max( :weight );
						ytargetmin = Col Min( :weight );
						ytargetp = (ytargetmax - ytargetmin) / 100;
						ymax = Col Max( :height );
						ymin = Col Min( :height );
						yrange = ymax - ymin;
					);
					yp = ((:height - ymin) / yrange) * 100;
					ytargetmin + ytargetp * yp;
				)
			)
		)
	),
	Elements(
		Bar( X, Y, Legend( 5 ), Bar Style( "Needle" ), Response Axis( "X" ) )
	)
);

gb2 = dt << Graph Builder(
	Size( 528, 454 ),
	Show Control Panel( 0 ),
	Variables( X( :r ), Y( :weight ) ),
	Elements( Line( X, Y, Legend( 5 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"weight",
			ScaleBox,
			{Min( 60.8877083333333 ), Max( 178.48 ), Inc( 20 ), Minor Ticks( 0 )}
		)
	)
);


report(gb1)[framebox(1)]<<copy frame contents;
report(gb2)[framebox(1)]<< paste frame contents;

gb1<<close window;

Re: Can JMP draw this pattern?

lala — Sat, 11 Jun 2022 03:55:23 GMT

Thank Jim!

This is exactly what I want.How do I change the color of GB1 (bar chart) to red?I still haven't learned.

Re: Can JMP draw this pattern?

txnelson — Sat, 11 Jun 2022 04:20:06 GMT

The lines are combined with the line chart, which means whatever the line color is, the needles will be the same.

Re: Can JMP draw this pattern?

lala — Mon, 13 Jun 2022 08:19:59 GMT

Re: Can JMP draw this pattern?

lala — Mon, 20 Jun 2022 08:11:02 GMT

Go ahead and ask the experts: can these different forms of the graph be added together?

Thanks!

Re: Can JMP draw this pattern?

txnelson — Mon, 20 Jun 2022 10:58:55 GMT

Yes. Graph Builder can easily do this.

I added a transform column set to the Row() and used it for the X axis
I dragged Height and weight to the Y axis
Moved Weight to the right side axis
Then I went into the axis settings for each axis and removed all tick marks and labels.

Documentation on Graph Builder is in the Essential Graphing document

Re: Can JMP draw this pattern?

lala — Mon, 20 Jun 2022 11:48:53 GMT

Thank Jim!

I tried to do it, but at step 4 I couldn't figure out how to do it.And I don't know if I'm dragging correctly?

Re: Can JMP draw this pattern?

txnelson — Mon, 20 Jun 2022 11:55:56 GMT

Do not create a Group Y, you need to move the axis to the right,.

Re: Can JMP draw this pattern?

lala — Mon, 20 Jun 2022 12:23:52 GMT

Thank Jim!
This time I learned. But tried to change the color of the height .

Re: Can JMP draw this pattern?

txnelson — Mon, 20 Jun 2022 12:29:33 GMT

Right click on the legend entry for the line and select Line Color

Re: Can JMP draw this pattern?

lala — Mon, 20 Jun 2022 12:35:48 GMT

Thank Jim!

Re: Can JMP draw this pattern?

lala — Tue, 21 Jun 2022 12:42:31 GMT

Thanks Experts!

Re: Can JMP draw this pattern?

lala — Tue, 21 Jun 2022 12:30:52 GMT

After this, how to use different colors for the "weight" bar chart according to the "gender".Does this "needle" shape reflect different colors?

I still need expert help.

Thanks!