topic Bulk change to log scale and color of reference line in Discussions

Bulk change to log scale and color of reference line

monu_maverick — Sun, 11 Jun 2023 11:26:34 GMT

Hi,

I used "fit y by x" in JMP16 to generate about 25 graphs. How can I change all of their scales to log scale without going to individual graph's axis settings please?

Also, each one of the graphs have their unique USL that gets displayed a reference line in color blue. How could I change all the 25 reference line's color from blue to red please?

Thanks!

Re: Bulk change to log scale and color of reference line

Mark_Bailey — Tue, 02 Aug 2022 15:17:18 GMT

If you used a variable with 25 levels in the By role so that all the plots are in the same window, then right-click on the axis that you changed and select Copy Axis Settings. Then press and hold the CTRL key (Windows) or the Command key (Mac), right-click on the axis of another plot and select Paste Axis Settings.

Re: Bulk change to log scale and color of reference line

monu_maverick — Tue, 02 Aug 2022 15:58:23 GMT

Hi Mark,

Thanks for sharing the tip. Unfortunately, when I do that following 2 things happen,

- The y-axis data range is different for all the 25 graphs and hence upon pasting the axis settings the data points move outside of the visible range.

- Each graph has its own unique spec limit, thus, when i paste the axis settings the spec limits from source graph gets pasted to the new graph and i have more than 1 spec limit

I have attached semiconductor capability.jmp as an example. See script "Fit Y by X - log scale 2" please

Re: Bulk change to log scale and color of reference line

Mark_Bailey — Tue, 02 Aug 2022 16:35:51 GMT

I think that the solution might be more complicated than I thought at first. It will require scripting. I do not have time to write a script at the moment.

Re: Bulk change to log scale and color of reference line

jthi — Tue, 02 Aug 2022 16:55:02 GMT

Changing Y-axis is fairly easy

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");

fg = dt << Fit Group(
	Oneway(Y(:NPN1), X(:lot_id)),
	Oneway(Y(:PNP1), X(:lot_id)),
	Oneway(Y(:PNP2), X(:lot_id)),
	Oneway(Y(:NPN2), X(:lot_id)),
	Oneway(Y(:PNP3), X(:lot_id)),
	<<{Arrange in Rows(1)}
);

axis_box_refs = (Report(fg) << XPath("//OutlineBox[starts-with(text(), 'Oneway Analysis of')]//AxisBox"));
axis_box_refs[1::N Items(axis_box_refs)::2] << Scale("Log");

updating colors of reference lines is most likely a bit more difficult and and will depend on where you are getting the limits from.

Re: Bulk change to log scale and color of reference line

monu_maverick — Tue, 02 Aug 2022 18:02:04 GMT

Thanks jthi. This worked for changing to log scale