JSL plus powerpoint opens some really fantastic options.
In powerpoint there is an option to insert an image and link to the file. It looks like this on a Mac, PC has the same thing from the insert down arrow button.
I used the script below to make a png file from my JMP report, then used the insert and link option in powerpoint. The same png is inserted two times, and scaled differently. The slide looks like this:
Close the powerpoint slide, then run the rest of the script and open the powerpoint slide again.
Upon re-opening the slide the figure now looks like this:
The really fantastic part of this is that you don't have to fight with sizing your graphs in JMP, all of that is done in powerpoint. The positioning and alignment of the images is done in powerpoint too. PPT essentially makes a box with a specified size and location and fits what ever the image file is, into that box. If your graphs get bigger or smaller, the get resized to the box automatically.
Granted, it's a little bit of a pain to set up the slides the first time, but after that it's super easy to do the updates.
Now, imagine using workflow builder in JMP, and inserting a custom action to save picture for each of your reports. You could run a workflow, and at the end have it open powerpoint, will all custom updated figures from the workflow. This is kind of huge, I'm not sure that many people are using this combination of features.
The script below looks kind of gnarly, but its just two Oneway reports with a little bit of important stuff at the bottom.
names default to here(1);
fig1 = Expr(
dt << Oneway(
Y( :weight ),
X( :age ),
Means and Std Dev( 1 ),
Mean Error Bars( 1 ),
Std Dev Lines( 1 ),
Histograms( 1 )
)
);
fig1color=expr(Oneway(
Y( :weight ),
X( :age ),
Means and Std Dev( 1 ),
Mean Diamonds( 1 ),
Mean Error Bars( 1 ),
Std Dev Lines( 1 ),
Histograms( 1 ),
SendToReport(
Dispatch( {}, "Oneway Report", FrameBox,
{DispatchSeg(
Hist Seg( 1 ),
{Line Color(
{0.424050015670061, 0.235950010555983, 0.255750002833103, "HLS",
0.982456147670746, 0.330000013113022, 0.284999996423721}
), Fill Color( "Red" )}
)}
),
Dispatch( {}, "Oneway Report", FrameBox( 2 ),
{DispatchSeg(
Hist Seg( 1 ),
{Line Color(
{0.424050015670061, 0.235950010555983, 0.255750002833103, "HLS",
0.982456147670746, 0.330000013113022, 0.284999996423721}
), Fill Color( "Red" )}
)}
),
Dispatch( {}, "Oneway Report", FrameBox( 3 ),
{DispatchSeg(
Hist Seg( 1 ),
{Line Color(
{0.433339169257448, 0.328609796907946, 0.226660856968595, "HLS",
0.0822122544050217, 0.330000013113022, 0.313148945569992}
), Fill Color( "Orange" )}
)}
),
Dispatch( {}, "Oneway Report", FrameBox( 4 ),
{DispatchSeg(
Hist Seg( 1 ),
{Line Color(
{0.433339169257448, 0.328609796907946, 0.226660856968595, "HLS",
0.0822122544050217, 0.330000013113022, 0.313148945569992}
), Fill Color( "Orange" )}
)}
),
Dispatch( {}, "Oneway Report", FrameBox( 5 ),
{DispatchSeg(
Hist Seg( 1 ),
{Line Color(
{0.430264771988581, 0.421629527767338, 0.229735254237463, "HLS",
0.159489631652832, 0.330000013113022, 0.303832590579987}
), Fill Color( "Yellow" )}
)}
),
Dispatch( {}, "Oneway Report", FrameBox( 6 ),
{DispatchSeg(
Hist Seg( 1 ),
{Line Color(
{0.253622181658831, 0.406377844567213, 0.265448424355718, "HLS",
0.346236556768417, 0.330000013113022, 0.231447964906693}
), Fill Color( "Green" )}
)}
)
)
););
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
rfig1 = fig1 << report;
rfig1 << Save Picture( "jmp_example.png", "png" );
//open("jmp_example.png");
open("Make Figure 1.pptx");
wait(1);//Actually, stop here. Run the above script and make a powerpoint slide using the insert and link file option.
//To keep things easy for this example, keep this script and the powerpoint file all in the same folder.
rfig1c = fig1color << report;
rfig1c << Save Picture( "jmp_example.png", "png" );
//Close the powerpoint slide, then open it again.
open("Make Figure 1.pptx");