Edit JMP plot format to export to power point

vikramavtar

When I export a journal with hundreds of plots, into a power point file, plot and summary stats are separated into 2 slides.
Is there a way to show everything shown in attachment (sample plot) in single power point slide ?

yes, I can export plots to pdf, but power point is what I am looking for.

I have tried to export the plots into HTML as well.

The individual images when exported into HTML do contain summary stats.

Only the plots are exported into images.

 

Please let me know if there is a way to fix above issues with either JSL/Some other method
Thank you

 

I am using JMP16

 

2024-11-13_20h32_34.png

Byron_JMP

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");