Tips and Tricks From Tables to Graphs and Beyond - Mastering JMP

JMP includes shortcuts and capabilities that can streamline your JMP analyses and reporting.  Learn interesting shortcuts and tips, including those new in the latest version of JMP.

In this session, we cover a variety of ways to easily format tables and graphs to simplify setting up analyses and presenting and drilling into reports.

Video was recorded in February 2025 using JMP 18.

See these tips:

• Help Yourself
  • Where to Learn More- inside of JMP
  • Help Menu inside of JMP
  • JMP Documentation - written like workbooks
  • Sample Data Files go with Documentation
  • Search JMP - find analyses, etc.
• Where to Learn More: Outside of JMP
  • JMP Community Learn JMP Page
• Question Mark Tool (?)
• Fast Tool Switching
  • Switch tools with a single keystroke. See Keyboard Shortcuts
  • A = Arrow
  • B = Brush
  • C = Crosshair
  • H = Hand
  • L = Lasso
  • R = Scroller
  • S = Selection
  • T = Text Annotation
  • Z =  Zoom
  • ? = Help
• Open and Close Many Files
  • Open multiple files at the same time
  • File > Import Multiple Files (Windows)
  • File -> Open Multiple (MacOS)
•  Close Multiple Tables at same time
  • File > Close Multiple (Mac)
  • Home Window > Select Files > Right Click > Close (Windows)
• Import table from the Internet
  • Internet Open
  • Internet Open: File-> Internet Open
• Data Table Tips
  • Tools on the Data Table
  • Blank Triangles reset row and column selections
  • Header Graphs and Stats
  • Column Manager (Column Viewer older JMP versions)
  • Group Columns in Column Panel (also hide, exclude, scroll lock)
  • Rename columns using Recode Column Names.
  • Right Click the Data Table (Fill, Select Matching)
  • Standardize Attributes (Column Properties)
  • Instant Formula (right click Column Name)
  • Recode - data cleanup
• Working with Reports
  • Key Tools in Reports
    • Top Red Triangle ->  bottom section
    • Local Data Filter
    • Redo-> Column Switcher
    • Redo -> Redo and Relaunch Analysis
    • Save Script
  • Keyboard Commands
    • Broadcasting the hot spot selection: CTRL + click
    • Alt - Hotspot to execute multiple selections
    • Right Click Summary Tables in Reports
  • Axis Adjustments
    • Hand Tool (3 positions)
    • Right Click options (Revert Axis)
    • Double Click for Control Panel
  • Data Points
  • Select
  • Color, Mark, Label
  • Name Selection in Column
  • Save Row States in Data Table Column
• Hover Labels
  • Add Context with Hover Labels
  • Pictures as Labels
  • Edit Label
  • Graphlets and Gridlets
  • Drill down graphs
• Workflow Builder
  • Open Workflow Builder and Record
  • Workflow Builder Records JMP Actions in One Replayable Script
  • Capture and record actions in JMP
  • File -> New Workflow
  • Use the Log

Questions answered by @Laura_Higgins , @DonnyKopp  and @HydeMiller at the live webinar:

Q: Where can I get the documentation Add-In?

A: In the JMP Marketplace. 

Q: Does Workflow Builder generate a script for each of the task done to automate similar tasks?

A: Yes. A script is always generated in the background and when doing most things in JMP.  See the Mastering JMP video on using Workflow Builder. 

Q: If you are in Graph Builder, and you press "z" for the magnifying glass, and nothing happens, what do you typically do next to make it work?

A: You can also click on the magnifying button in the menu/toolbar.

Q: Re. the Columns Manager, is it possible to change the data type of multiple variables all at once?

A: Yes, Columns Manager is the easiest way to do this.  From the top right panel, select multiple rows in the viewer and use the drop-down menus.

Q: What's the best way to get a nice summary of my data (Means, Standard Deviations, etc.) in a JMP report that is formatted nicely and which I can put in a PowerPoint presentation?

A: Analyze > Distribution > select the columns you'd like to see > OK > File > Export > Microsoft PowerPoint.  Or, you might like File>Export and then select PowerPoint and save to a dummy document.  You will have all the summarized data as objects that can be resized & copy/paste into your presentation.

Q: Can you do Hover labels when presenting in PowerPoint?

A: No, once in PowerPoint you are limited to its capabilities. However, one way I've seen this done is to record a short video of the graph and showing the hover graphs of interesting points, then embed the video into PowerPoint.

Q: How do I find Past Mastering JMP videos?

A: Search community.jmp.com/mastering and filter for Series Mastering JMP and Event Status Past Mastering JMP.  Using the filters you can find the video on Journals.

Findng past Mastering JMP videos from community.jmp.com/mastering

Resources

• English JMP Documentation Add-In  shown in video. 
• Mastering JMP video on  Creating Custom Drill-Down Graphs. 
• Mastering video on Automating Your Analyses Using Workflow Builder .