Automation of Reports for PowerPoint Templates with JMP 15

[#1]

Hi all,

I run weekly reports on physiochemical attributes. The old process was to manually input data from excel into JMP. After entering the new data into JMP two scripts are run: Run Chart and Control Chart scripts, that are saved to the Data Table. These scripts have limits of precision and formatting applied (or saved into the scripts). Then the charts are copy & pasted one by one into a PowerPoint presentation. 

I was wondering can this process be automated? 

I have added a script that allows me to automatically update the Data Table. 

I would love to be able to simply generate the PowerPoint presentation with just a click of a button instead of having to copy and paste each graph into the report.

Every script I have attempted always lets me down.

I would like to know if anyone could point me in the right direction or if this can even be done (see below).

In my head I would like -
1. A script to update the data table ( I have achieved already)
2. Run scripts for Run Charts and Control Charts so I can update the x axis (drag new data in and drag the old data off the x-axis. Then save the updated graphs

3. Add a final script that would automatically add the updated Run Charts and Control Charts to a formatted PowerPoint presentation.


Thanks for any advice.

[#2]

maybe try doing it like this?

https://community.jmp.com/t5/Byron-Wingerd-s-Blog/Saving-a-list-of-control-charts-as-graphic-files/b...

[#3]

Hi Sean,

Yes, your process can definitely be automated with the right combination of scripting in JMP and PowerPoint integration. Since you’ve already automated updating your Data Table, the next steps would be to script the chart generation and then export those charts directly into a PowerPoint presentation.

1. Chart Automation: You can create a JMP script that automatically runs your Run Chart and Control Chart scripts on the updated data. Make sure the scripts are modular so that they accept the new Data Table as input, updating axes and formatting dynamically.

2. Export to PowerPoint: JMP scripting (JSL) allows you to export graphs as images or directly interact with COM objects in PowerPoint (on Windows). You could write a final script that takes all the updated charts and inserts them into a pre-formatted PowerPoint template. If you don’t have a ready template, using Free PowerPoint Templates available online can help you maintain consistent formatting, slide layout, and branding.

3. One-Click Automation: By combining these steps into a master JSL script, you can generate the complete presentation with just one click, bypassing the manual copy-paste step entirely.

You might want to start by testing chart export functions to PNG or EMF, then automate inserting those images into a PowerPoint slide. Once that works reliably, you can extend it to fully formatted slides using a template.

If you need, I can share a small example script snippet for exporting JMP charts to PowerPoint slides—it’s a great way to get started with full automation.

[#4]

Hello,

We've already had to do this for a client with the exact same request. Ultimately, what we did was use a JSL script that copied the (empty) PPTX template and then populated it incrementally with elements from JMP analysis, like control charts etc, using JSL command 'Save Presentation' . However, the result was a bit "raw," so we added a layer by calling a VBA script (or a Python script with the package pptx) within the JSL to format the rendering (centering images, font size, header, etc.).

https://community.jmp.com/t5/Abstracts/From-Data-to-Decision-Automated-SQC-Reporting-and-Seamless-ME...