Subscribe Bookmark RSS Feed

Exporting Graphs from Graph Builder to Excel

markbyrd

Occasional Contributor

Joined:

Aug 23, 2017

I created a signifciant number of box-and-whister graphs that I want to be able to export them, one graph at a time, to my Excel file where I am telling a story about the data.   I have tried several methods, mostly trying to create pic files using jpeg but with so many graphs I can't seem to seperate the graphs.  Does anyone have any thoughts or information on ways you have been able to export graphs that you have produced in Graph Builder to Excel?   I am just looking to get multiple images above various tables.  Thanks for any advice!  

Mark

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Peter_Bartell

Joined:

Jun 5, 2014

Solution

If i interpret what you are trying to accomplish correctly, It's not exporting to Excel...but if all you are really using Excel for is as a recipient MS application for the multitude of graphs you've built in Graph Builder have you considered using the native to JMP en masse export capability into MS Word or PowerPoint, rather than Exel? The beauty of this workflow is if you've got a large number of graphs you want to export to a destination MS application, with a short workflow you can mass export ALL the graphs to the destination application.

 

The workflow is, first create all your graphs in the current JMP session, then from the JMP main menu bar, select File Save As, then from the File as type: window, select PowerPoint Presentation (*.pptx). Select Save. What happens is JMP calls a blank PowerPoint template that shipped with JMP, and deposits one visualization per PowerPoint slide, with a default slide title header and footer. From there you can edit each slide as you see fit within the PowerPoint application. Similar workflow for MS Word as well.

 

If you MUST use Excel as your reporting tool...maybe embedding a PowerPoint object created above, within the Excel worksheet could work too?

Peter_Bartell

Joined:

Jun 5, 2014

Solution

Shame on me for not including a link to the JMP online documentation providing lots of additional details and tips related to my initial reply above.

 

Here it is:

 

http://www.jmp.com/support/help/13-2/Save_as_PowerPoint.shtml

 

One thing some of my JMP customers also do is replace the blank generic PowerPoint template shipped with JMP with one of their own company/organizations blank PowerPoint templates. That way, the JMP graphs, charts, and tables all populate right into your own designated organization's template. The naming convention and file location for the JMP supplied template are in the documentation.

 

Good luck.

9 REPLIES
pmroz

Super User

Joined:

Jun 23, 2011

How about using copy/paste?  In a JMP graph window hit the S key (or click on the cross selection tool).  Highlight what you want to copy and hit CTRL-C.  Go to Excel and hit Paste Special, and select Picture (Enhanced Metafile).

markbyrd

Occasional Contributor

Joined:

Aug 23, 2017

That method selects every graph that I created in the window. It will not allow me to select one graph at a time.
Peter_Bartell

Joined:

Jun 5, 2014

Solution

If i interpret what you are trying to accomplish correctly, It's not exporting to Excel...but if all you are really using Excel for is as a recipient MS application for the multitude of graphs you've built in Graph Builder have you considered using the native to JMP en masse export capability into MS Word or PowerPoint, rather than Exel? The beauty of this workflow is if you've got a large number of graphs you want to export to a destination MS application, with a short workflow you can mass export ALL the graphs to the destination application.

 

The workflow is, first create all your graphs in the current JMP session, then from the JMP main menu bar, select File Save As, then from the File as type: window, select PowerPoint Presentation (*.pptx). Select Save. What happens is JMP calls a blank PowerPoint template that shipped with JMP, and deposits one visualization per PowerPoint slide, with a default slide title header and footer. From there you can edit each slide as you see fit within the PowerPoint application. Similar workflow for MS Word as well.

 

If you MUST use Excel as your reporting tool...maybe embedding a PowerPoint object created above, within the Excel worksheet could work too?

markbyrd

Occasional Contributor

Joined:

Aug 23, 2017

This seems such a simple but wonderful solution. I will try that in both PPT and Word to see what which results in the best possible graph. Thanks so much for the solution that I know I will likely use a lot.
Peter_Bartell

Joined:

Jun 5, 2014

Solution

Shame on me for not including a link to the JMP online documentation providing lots of additional details and tips related to my initial reply above.

 

Here it is:

 

http://www.jmp.com/support/help/13-2/Save_as_PowerPoint.shtml

 

One thing some of my JMP customers also do is replace the blank generic PowerPoint template shipped with JMP with one of their own company/organizations blank PowerPoint templates. That way, the JMP graphs, charts, and tables all populate right into your own designated organization's template. The naming convention and file location for the JMP supplied template are in the documentation.

 

Good luck.

Peter_Bartell

Joined:

Jun 5, 2014

One other thought for you is have you considered using JMP journaling as well? Journals offer lots of useful capabilities beyond just sharing JMP results in presentation mode. You can embed files (JMP and otherwise), web links, insert pictures, so if you are giving a presentation of findings, you can put pretty much anything you'd put into a PowerPoint presentation and NEVER leave the JMP ecosystem.

 

http://www.jmp.com/support/help/13-2/JMP_Journals.shtml

 

 

markbyrd

Occasional Contributor

Joined:

Aug 23, 2017

I am not familiar with this, but I will certainly look into it. Depending on how it looks and if it works I am anxious to read more about it and try it out. Thank you
markbyrd

Occasional Contributor

Joined:

Aug 23, 2017

I was following the example of making a Journal for a Presentation, and I went to File>New>Journal and when to right click to add Outline but it was not on my list.  I am not sure why it is not there, I am running 13.2.  Thoughts?  

Peter_Bartell

Joined:

Jun 5, 2014

@markbyrd: When you right click is your cursor in the blank space of the newly created journal? If it is...I'm at a loss as to why the drop down containing all the options, new outline item, being one of them, aren't appearing. You may want to contact JMP tech support at support@jmp.com.