Data Visualized. Understanding Realized.

Video using JMP 18 was posted in June 2025.

Do you want to uncover patterns and relationships in your data? Do you need to interpret graphs to support decision-making?

In this session we show how to:

• Create, interact with and interpret a variety of graphs.
• Visually  explore multiple variables.
• Identify key drivers of yield.
• Track changes over time.

Suggested  prerequisites:

• Familiarity with understanding the main attributes of JMP data tables.
• Basic navigation of JMP menus.

Try these suggested follow-on activities:

• Types of graphs you can use to understand your data
• Hands-On Activity for using Graph Builder
• Video and materials on using JMP Hover Graphs and Hover Labels

Questions answered by @Peter_Hersh and @Laura_Higgins  at the live webinar:

Q: How could you set up conditional formatting, so points change shape/color to align with good/bad/ ok ranges?

A: You could do it with a formula. The colors are called row states.

Q: How is the color in the Sankey/Parallel Plot determined. Is it by the colors stored in the row states, the majority of the data points, or some other criterion?

A: One way is to use a column for the “color” in that graph. You can drop a column into the “color” like “pass, fail” and then it colors the graph.

Q: Can the column switcher function be used with most graph types?

A: Yes. Column switcher is in almost EVERY platform, in the same place in the top triangle of tools. Start with an analysis graph.  Then, enable Column Switcher from red triangle Redo Column Switcher. Add variables you want to use to switch between. To run, click on a variable name in the control panel, and the analysis will automatically update with the selected variable.

Q: Can I use a row state column as "overlay" or "color" in graph builder? I think the column is just visible in the data table, but not in the Graph Builder window.

A: You would have to change the Row State Column into a regular data column. You can do that with a formula.

Q:.  How do you embed copied graph script into the bar graph.

Q: How do you interpret the graph that contains the Parallel Plot interweaving lines?

A: You can interpret them as a sort of process flow.  See video below.

Resources

The JMP LearnBot Add-In often gives great answer to questions.  For example, form JMP I asked it ‘column switcher’ and got:

In JMP, you can change row states using formulas by creating a column designated as a "Row State" column and applying a formula to assign specific row states. Here's how you can do it:

Steps to Change Row State Using a Formula:

1. Create a Row State Column:
• Go to Cols > New Column.
• In the "Column Info" window, set the Data Type to "Row State".
• Click OK.
2. Apply a Formula to Assign Row States:
• Right-click the newly created Row State column and select Formula.
• Use the Formula Editor to define the row state logic. You can use the following row state functions:
• Excluded State: Assigns the excluded condition when the argument evaluates as true.
• Hidden State: Assigns the hidden condition when the argument is greater than zero.
• Labeled State: Assigns the labeled condition when the argument is greater than zero.
• Selected State: Assigns the selected condition when the argument evaluates as true.
• Combine States: Combines multiple row state conditions.
3. Example Formulas:
• To exclude odd-numbered rows:

Copy Code - Excluded State(Modulo(Row(), 2))

• To hide rows where a column value is greater than 10:

Copy Code - Hidden State(If(:ColumnName > 10, 1, 0))

• To label rows where a column value equals "A":

Copy Code - Labeled State(If(:ColumnName == "A", 1, 0))

1. Combine Multiple Row States:
• You can use the Combine States function to assign multiple row states to a single row. For example:

Copy Code -Combine States(Selected State(Modulo(Row(), 2)), Labeled State(Modulo(Row() + 1, 2)))

1. Save and Apply:
• Once the formula is defined, click OK to save it. The row states will automatically update based on the formula.

Notes:

• A row state column stores information about whether rows are excluded, hidden, labeled, colored, marked, or selected.
• If you include conflicting row states in a combination, the results may be unpredictable.