topic Re: Scatter plot x and y axis values in Discussions

Scatter plot x and y axis values

Mickyboy — Sun, 11 Jun 2023 11:02:49 GMT

Hi All,

i would like to replicate the following scatter plots in JMP, the problem i am having is when i go to axis setting and request a log scale with a base 2 the scale starts from 1, so the scales is 1,2,4,8,16, 32, 64 etc i would like it to start at 5, 10, 20,40, 80,160,320 etc does anyone have any advice??

Any help would be appreciated.

Thanks

Re: Scatter plot x and y axis values

Georg — Tue, 30 Jun 2020 09:19:08 GMT

@Mickyboy I cannot reproduce your Problem,

for me it worked, see attached JMP file (JMP15@Win10).

Perhaps you Need to again set the axis range, sometimes many steps at one don't work.

Re: Scatter plot x and y axis values

Mickyboy — Tue, 30 Jun 2020 10:18:54 GMT

Hi Georg,

Thanks for the reply, on checking my post i may not have explained that as well as i could have, l have data but l would like the the axis the same as the picture l supplied, that is a log base 2 increase commencing at 5, so 5,10,20,40,80,160,320,640 etc, which l cant seem to manage, for reference please see the attachment to this post

Thanks

Re: Scatter plot x and y axis values

gzmorgan0 — Tue, 30 Jun 2020 12:44:45 GMT

@Mickyboy ,

To show you that this is possible here is a GraphBuilder plot of data I guessed from one of your plots. I added the Line of Fit and Major Grid.

The way I did this is to :

transform the X and Y data,
use a linear scale
but customize the format

I did this using the UI, but copied the sccript to the data table whicj is attached.

The script is shown here:

Graph Builder(
	Size( 534, 490 ),
	Show Control Panel( 0 ),
	Show Legend( 0 ),
	Variables(
		X(
			Transform Column(
				"Transform[Ref Lab]",
				Formula( Log( :Ref Lab / 5, 2 ) )
			)
		),
		Y(
			Transform Column(
				"Transform[Non-Ref]",
				Formula( Log( :Name( "Non-Ref" ) / 5, 2 ) )
			)
		)
	),
	Elements(
		Points( X, Y, Legend( 5 ) ),
		Line Of Fit( X, Y, Legend( 7 ), Adapt to Axis Scale( 0 ) )
	),
	SendToReport(
		Dispatch(
			{},
			"Transform[Ref Lab]",
			ScaleBox,
			{Format( "Custom", Formula( 2 ^ value * 5 ), 9, 0 ), Min( 0 ), Max( 9 ),
			Inc( 1 ), Minor Ticks( 0 ), Label Row( Show Major Grid( 1 ) )}
		),
		Dispatch(
			{},
			"Transform[Non-Ref]",
			ScaleBox,
			{Format( "Custom", Formula( 2 ^ value * 5 ), 30 ),
			Label Row( Show Major Grid( 1 ) )}
		),
		Dispatch( {}, "X title", TextEditBox, {Set Text( "Ref Lab" )} ),
		Dispatch( {}, "Y title", TextEditBox, {Set Text( "Non-Ref Lab" )} )
	)
)

Re: Scatter plot x and y axis values

gzmorgan0 — Tue, 30 Jun 2020 12:50:05 GMT

oh, since this is the first time I used this feature, I thought it might be useful to show the axis settings

Here is the Custom Format screenshot, the window that pops up when you press the Custom button

Re: Scatter plot x and y axis values

Mickyboy — Wed, 01 Jul 2020 02:32:31 GMT

Hi gzmorgan0,

Thanks for coming to my aid again, and thanks very much for your solution, its brillant, a couple of problems i have in getting the presentation l am after, and i dont know if its possible. Unfortunately l am still stuck with JMP 14 and dont have the custom area in axis setting's.

l can't get the y axis to start at 5, i have tried including the Min () and Max() into the script but to no avail

Graph Builder(
	Size( 534, 490 ),
	Show Control Panel( 0 ),
	Show Legend( 0 ),
	Variables(
		X(
			Transform Column(
				"Transform[Lab B]",
				Formula( Log( :Lab B / 5, 2 ) )
			)
		),
		Y(
			Transform Column(
				"Transform[Lab A]",
				Formula( Log( :Name( "Lab A" ) / 5, 2 ) )
			)
		)
	),
	Elements(
		Points( X, Y, Legend( 5 ) ),
		Line Of Fit( X, Y, Legend( 7 ), Adapt to Axis Scale( 0 ) )
	),
	SendToReport(
		Dispatch(
			{},
			"Transform[Lab B]",
			ScaleBox,
			{Format( "Custom", Formula( 2 ^ value * 5 ), 30 ), 
			Label Row( Show Major Grid( 1 ) )}
		),
		Dispatch(
			{},
			"Transform[Lab A]",
			ScaleBox,
			{Format( "Custom", Formula( 2 ^ value * 5 ), 30 ), 
			Label Row( Show Major Grid( 1 ) )}
		),
		Dispatch( {}, "X title", TextEditBox, {Set Text( "Lab B" )} ),
		Dispatch( {}, "Y title", TextEditBox, {Set Text( "Lab A" )} )
	)
)

Also is it possible to have the reference line run though the graph as per the response variable in the attached data file??? l would like the line to represent where the expected titers should lie.

Again thanks very much for your help, its greatly appreciated.

Re: Scatter plot x and y axis values

gzmorgan0 — Wed, 01 Jul 2020 04:53:26 GMT

@Mickyboy ,

I am not sure why/where the 30 value in the saved script in JMP15 comes from. Note you can drag using the grabber to get 5 th be the minimum on the axes. I didn't look at your plot very closely. The line is the line Y=X and that can be added with right click Customize the FrameBox. The scipt is included below.

If using the same scales you might want to right click in the framebox, select Graph and size and scale isometric. Up to you.

Graph Builder(
	Size( 534, 484 ),
	Show Control Panel( 0 ),
	Show Legend( 0 ),
	Variables(
		X(
			Transform Column(
				"Transform[Ref Lab]",
				Formula( Log( :Ref Lab / 5, 2 ) )
			)
		),
		Y(
			Transform Column(
				"Transform[Non-Ref]",
				Formula( Log( :Name( "Non-Ref" ) / 5, 2 ) )
			)
		)
	),
	Elements( Points( X, Y, Legend( 3 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"Transform[Ref Lab]",
			ScaleBox,
			{Format( "Custom", Formula( 2 ^ value * 5 ), 9 )}
		),
		Dispatch(
			{},
			"Transform[Non-Ref]",
			ScaleBox,
			{Format( "Custom", Formula( 2 ^ value * 5 ), 9 ), Min( 0 ), Max( 9 ),
			Inc( 1 ), Minor Ticks( 0 )}
		),
		Dispatch( {}, "X title", TextEditBox, {Set Text( "Ref Lab" )} ),
		Dispatch( {}, "Y title", TextEditBox, {Set Text( "Non- Ref Lab" )} ),
		Dispatch(
			{},
			"Graph Builder",
			FrameBox,
			{Marker Size( 5 ), Add Graphics Script(
				2,
				Description( "Script" ),
				Pen Color( "black" );
				Pen Size( 2 );
				Line Style( "Dotted" );
				Y Function( x, x );
			), Grid Line Order( 1 ), Reference Line Order( 3 )}
		)
	)
)

Re: Scatter plot x and y axis values

gzmorgan0 — Wed, 01 Jul 2020 04:54:50 GMT

oops forgot to add that the above graph and script is from JMP 14

Re: Scatter plot x and y axis values

Mickyboy — Wed, 01 Jul 2020 04:55:29 GMT

Hi gzmorgan0,

Something interesting happened when l ran the same syntax over another similar dataset with higher titers

l dont' know why but now the scaling is slight awry on both axis with 10 and 10,240 missing.

Thanks

Re: Scatter plot x and y axis values

Mickyboy — Wed, 01 Jul 2020 06:10:37 GMT

Hi gzmorgan0,

l completely forgot about the grabber, the 30 in my syntax must have been a leftover from somethings l was trying, have fixed both graphs now and am very gratefull for your help, interestingly when i use the pull down menu's for graph bulider l dont get the custom button, but when i run the syntax and click on the axis for axis settings l can see the box.

Again thanks very much for your help and guidance.

Re: Scatter plot x and y axis values

gzmorgan0 — Wed, 01 Jul 2020 17:52:14 GMT

@Mickyboy,

The tick increment is 2. This is happening either because inc is 2 or your frame size needs to be bigger to show all ticks.

Re: Scatter plot x and y axis values

Mickyboy — Wed, 01 Jul 2020 22:50:27 GMT

Hi gzmorgan0,

no problems, i worked it out, thanks very much

Re: Scatter plot x and y axis values

Mickyboy — Wed, 15 Jul 2020 06:22:02 GMT

Hi @gzmorgan0 ,

I need your assistance again if possible, i need another two reference lines on my chart, you produced the syntax for the equality reference line where x=y, if i wanted a line two represent a 100% increase for the values of x when the values of y = the original references line, so x= 5, 10, 20, 40, 80, 160, 320, 640, 1280, 2560 where y= 10, 20, 40, 80,160, 320, 640, 1280, 2560, 5120. Is this possible?

Re: Scatter plot x and y axis values

Mickyboy — Wed, 15 Jul 2020 07:13:14 GMT

Hi @gzmorgan0,

Its Ok, I have worked it out, I think I'm learning!!

Dispatch(
			{},
			"Graph Builder",
			FrameBox,
			{Marker Size( 5 ), Add Graphics Script(
				2,
				Description( "Script" ),
				Pen Color( "black" );
				Pen Size( 2 );
				Line Style( "Dotted" );
				Y Function( x, x );
			), Add Graphics Script(
				4,
				Description( "Script" ),
				Pen Color( "red" );
				Pen Size( 2 );
				Line Style( "Dotted" );
				X Function( y - 1, y );
			), Add Graphics Script(
				5,
				Description( "Script" ),
				Pen Color( "red" );
				Pen Size( 2 );
				Line Style( "Dotted" );
				X Function( y + 1, y );
			), Grid Line Order( 1 ), Reference Line Order( 3 )}
		)
	)
);

Re: Scatter plot x and y axis values

gzmorgan0 — Wed, 15 Jul 2020 07:41:57 GMT

Congratulations!

Re: Scatter plot x and y axis values

Mickyboy — Wed, 15 Jul 2020 07:45:07 GMT

@gzmorgan0,

thanks mate, I really do try to do a lot by myself, sometimes i jump the gun in asking for help, need a little more patience and belief!!!

Thanks again

Re: Scatter plot x and y axis values

Mark_Bailey — Wed, 15 Jul 2020 11:01:51 GMT

The expression for the identity line:

Y Function( x, x );

in the graphics script becomes this expression for the 100% increase:

Y Function( 2*x, x );

Re: Scatter plot x and y axis values

gzmorgan0 — Wed, 15 Jul 2020 14:31:37 GMT

Hi Dan,

@Mickyboy figured out a solution, but he posted it a couple enties above. The graph is rather unusual. The original task was to create a custom scale where the ticks/units were 5 * 2^x. I reposted the small table with script attached.

Due to the unusual power scaling, of this graph, a solution to this the 100% increase/decrease is

Y Function( x - 1, x) and Y Function(x + 1, x)

or as Mickey figured out X Function( y - 1, y) and X Function( y + 1, y)

Log and Power scaled axes can be challenging when it comes to reference functions.

Re: Scatter plot x and y axis values

Mickyboy — Thu, 16 Jul 2020 00:04:23 GMT

Hi @Mark_Bailey.,

Thanks for your input, appreciate it, i eventually figured it out.

Regards

Mick