topic Re: How can I change all X axes in a graph builder to log scale in Discussions

How can I change all X axes in a graph builder to log scale

JustinSuIntel — Sun, 11 Jun 2023 12:03:31 GMT

Double-clicking through the axes is a real headache.

Re: How can I change all X axes in a graph builder to log scale

txnelson — Wed, 05 Apr 2023 12:01:44 GMT

One way to handle this, is to use Standardize Attributes to change the Axis Column Property.

To change all of the axes to log:

Go to the data table, and select the columns you want change the axes for
Select Cols=>Standardize Attributes
Select Column Properties=>Axis
Click on Set Default Axis Settings
Change the Scale from Linear to Log
Click OK

The axes for all of the X axes in the graph will be changed to a log scale

Re: How can I change all X axes in a graph builder to log scale

JustinSuIntel — Wed, 05 Apr 2023 16:33:44 GMT

Thanks a lot for the suggestion.

However, my use of Graph Builder is quite dynamic and often hard to predict what columns will be used for plotting.

Is there a script that I can use to convert the X axes already used by a Graph Builder figure?

For example, I know I can do that for scatterplot matrix with

	For( i = 100, i < 200, i++,
		(Current Window() << XPath( "//ScaleBox[@charID=" || Char( i ) || "]" )) << Revert Axis
		 << {Scale( "Log" ), Inc( 1 ), Minor Ticks( 1 )}
	)

Re: How can I change all X axes in a graph builder to log scale

Mark_Bailey — Wed, 05 Apr 2023 17:32:17 GMT

You do not need to iterate. The list of display boxes will distribute the messages it receives to each of its items automatically, so you only need to make sure that the list is correct. For example:

Names Default to Here( 1 );

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

sm = dt << Scatterplot Matrix(
	Y( :Age, :Weight, :Oxy, :Runtime, :RunPulse, :RstPulse, :MaxPulse ),
	Matrix Format( "Lower Triangular" )
);
(Report( sm ) << XPath( "//AxisBox" ))
	<< Revert Axis
	<< Scale( "Log" )
	<< Inc( 10 )
	<< Minor Ticks( 0 );

Re: How can I change all X axes in a graph builder to log scale

JustinSuIntel — Thu, 06 Apr 2023 18:04:50 GMT

My problem is that I want to keep y axes in linear scale but change x axes into log scale. Without iteration, I am afraid that both X/Y axes will be switched to log scale.

By the way, does similar approach work for Graph Builder?

Re: How can I change all X axes in a graph builder to log scale

Mark_Bailey — Thu, 06 Apr 2023 19:38:41 GMT

This approach still works. Subscript the list first to get a new list with only the axis boxes you want to change, then send the messages to that target list. This way is still much easier and cleaner than explicit looping.

Here is a modification to my first example to illustrate the new approach:

Names Default to Here( 1 );

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

sm = dt << Scatterplot Matrix(
	Y( :Age, :Weight, :Oxy, :Runtime, :RunPulse, :RstPulse, :MaxPulse ),
	Matrix Format( "Lower Triangular" )
);

// change X axes only in Scatterplot Matrix
axes = Report( sm ) << XPath( "//AxisBox" );
nAxes = N Items( axes );

// second half of list only
axes[((nAxes/2)+1)::nAxes] << Select; // Scale( "Log" );

It doesn't work well with the Scatterplot Matrix, though, because all but one data column is used in the X and Y role, and internal logic tries to keep changes consistent in both places (X and Y role).

Re: How can I change all X axes in a graph builder to log scale

JustinSuIntel — Thu, 13 Apr 2023 17:13:07 GMT

Since I can't find a way to identify X axes from Y axes, my current solution is using this command to set all axes to log scale and then manually reverting Y axes to linear scale, which is much easier than manual setting of log scale.

( Current Window() << XPath( "//AxisBox" ) ) << Revert Axis << {Scale( "Log" ), Inc( 1 ), Minor Ticks( 1 )}