Using JMP • Enter and Edit Data • Assign Characteristics to Rows and Columns
Previous
 • 
Next
Assign Characteristics to Rows and Columns
This section describes how to exclude, hide, label, color, or mark rows and columns in order to customize the appearance of points in scatterplots and graphs. You can also lock columns so that they stay in place when you scroll through the data table.
The menu for row actions can be accessed from the following places:
•
the Rows menu in the main menu
•
right-click on a row
•
the red triangle in the Rows panel
•
the left red triangle in the upper left corner of the data grid
Similarly, the menu for columns actions can be accessed from the following places:
•
the Cols menu in the main menu
•
right-click on a column
•
the red triangle in the Columns panel
•
the right red triangle in the upper left corner of the data grid
Hide and Exclude Rows
Hiding and excluding rows means that they are hidden in plots and not analyzed.
To hide and exclude one or more rows from analyses
1.
Highlight one or more rows that you want to hide and exclude.
2.
Right-click on the selected rows and select Hide and Exclude.
or
From the Rows menu, select Hide and Exclude.
Exclude Rows and Columns
Marking rows and columns as excluded means that they are not analyzed. Note the following:
•
Excluded observations are excluded from calculations in text reports and graphs. For most platforms, excluded observations are not hidden in plots.
•
Use Hide/Unhide to hide observations in plots and graphs for most platforms. See Hide Rows and Columns.
•
A circle with a strikethrough () appears beside either the row number or the column name in the Columns panel. The circle indicates that the row or column is excluded and therefore not analyzed.
•
For most platforms, data remain excluded until you select Exclude/Unexclude again.
To exclude one or more rows from analyses
1.
Highlight one or more rows that you want to exclude.
2.
Right-click on the selected rows and select Exclude/Unexclude.
or
From the Rows menu, select Exclude/Unexclude.
To exclude one or more columns from analyses
1.
Highlight one or more columns that you want to exclude.
2.
Select Cols > Exclude/Unexclude or right-click select Exclude/Unexclude.
To unexclude rows or columns
1.
Highlight the excluded rows or columns that you want to include in your analyses.
2.
Select Exclude/Unexclude from the Rows menu or Cols menu. You can also right-click rows or columns and select Exclude/Unexclude.
Hide Rows and Columns
Marking rows and columns as hidden means that they do not appear in plots and graphs. Note the following:
•
Hiding rows and columns does not exclude them from analyses. They simply do not appear in plots and graphs.
•
To exclude hidden observations from analyses, use the Exclude/Unexclude option. See Exclude Rows and Columns.
•
A mask icon () appears beside the hidden row number or the column name, indicating that the row or column is hidden.
•
Observations remain hidden until you select Hide/Unhide again.
To hide one or more rows
1.
Highlight one or more rows that you want to hide.
2.
Right-click on the selected rows and select Hide/Unhide
or
From the Rows menu, select Hide/Unhide.
To hide one or more columns
1.
Highlight one or more columns that you want to hide.
2.
Select Cols > Hide/Unhide or right-click and select Hide/Unhide.
To unhide rows or columns
1.
Highlight the hidden rows or columns that you want to show in your plots and graphs.
2.
Select Hide/Unhide from the Rows menu or Cols menu. You can also right-click rows or columns and select Hide/Unhide.
Label Rows and Columns
When you position the arrow cursor over a point in a plot, the point’s label appears. By default, row numbers are used as labels. You can customize the labels as follows:
•
You can change the label to display column values instead of the row number.
•
You can enable the label to always appear, not only when you position the cursor over points.
•
A label or yellow tag icon () appears beside the column name in the Columns panel, indicating that points on plots are identified by the column value. If there are multiple columns that are labeled, their values appear on plots separated by a comma.
•
Data remain labeled until you select Label/Unlabel again.
To change the label to display column values
1.
Highlight one or more columns whose values you want to appear as the label in plots.
2.
Select Cols > Label/Unlabel from the menu or right-click and select Label/Unlabel.
To enable the label to always appear (not just when you position the cursor over points)
1.
Highlight one or more rows whose label you want to always appear in plots.
2.
Select Rows > Label/Unlabel from the menu.
To turn off labeling for rows or columns
1.
Highlight the labeled rows or columns that you no longer want labeled.
2.
Select Label/Unlabel from the Rows menu or Cols menu. You can also right-click columns or rows and select Label/Unlabel.
Assign Colors or Markers to Rows
•
If you assign a color to a row, the points representing the values in that row are colored in the plot.
•
If you assign a marker to a row, the point is replaced with the marker in the plot.
•
You can also assign colors or markers based on column values.
Assign a Color to Rows
Assigning a color to selected rows means that the points in plots appear in the color that you select. In the data grid, the active color assigned to a row appears next to the row number.
To assign rows a color
1.
Highlight one or more rows that you want to assign a color to.
2.
Right-click on the highlighted rows and select Rows > Colors.
3.
Select one of the available colors.
Tip: To clear an assigned color from the selected rows, assign the color black.
Add Markers to Rows
To replace the standard points in plots with a marker, use the JMP markers palette. In the data table, these markers also appear next to row numbers.
1.
Highlight one or more rows that you want to apply the marker to.
2.
Right-click on the selected rows and select Markers, and then select the marker shape.
Select Other to create custom markers. You can type alphabetic characters, numerals, and other keyboard symbols.
Tip: To return to the default marker, select the initial dot marker.
Assign Colors or Markers to Rows Based on Column Values
You can assign colors or markers to your data table rows based on the values found in a particular column. For example, in a column called Sex, you could assign all rows whose value is F a red circle marker. All rows whose value is M could have a green plus marker. These colors and markers replace the default black dot in plots and appear next to its row number in the data table.
To assign colors or markers to rows based on column values
1.
Select Rows > Color or Mark by Column.
2.
Select the column to color and or mark. See Color or Mark by Column.
Color or Mark by Column
3.
Select the Colors and Markers schemes to apply.
A preview of your selection appears under Row States.
4.
(Optional) Select any additional options. See Color or Mark by Column Options.
5.
Click OK.
6.
(Optional) To shade all rows according to their row state, right-click in the row numbers area within the data grid and select Color Rows by Row State.
From then on, the rows are shaded with the color that you assign to the rows.
Color or Mark by Column Options
Colors
select a color theme to assign different colors to the rows in your data table. Color assignment is based on the values of the selected column.
Continuous Scale
assigns colors in a chromatic sequence based on the values in the highlighted column.
Reverse Scale
assigns colors in a reversed chromatic sequence based on the values in the highlighted column.
Markers
assigns a different marker to each row in your data table based on the values found in the column that you highlighted.
Make Window with Legend
Includes a legend with your new characteristics so that you can easily identify which colors and markers correspond with which row.
Save To Column Property
saves the color and marker information as a column property. The rows in the selected column of the data table are colored, based on the color theme.
Save To Table Property
saves the color and marker information as a table property.
Excluded Rows
assigns colors or markers to rows that are excluded.
Create Color Themes
JMP includes several color themes that can distinguish a range of values in a graph. You can also create your own color themes based on an existing color theme or create custom themes.
Note: When you select a default color theme, the colors are not applied to reports that are open. You need to rerun the existing reports to format them with the default color theme.
See Delete Custom Color Themes for details about deleting custom color themes.
To create a color theme
1.
Select File > Preferences > Graphs.
2.
To either create a new Continuous Color Theme or Categorical Color Theme, click the appropriate color theme.
If you are creating a new continuous color theme, the Continuous Color Themes window appears.
Continuous Color Themes Window
If you selected to create a new categorical color theme, the Categorical Color Themes window appears.
Categorical Color Themes Window
3.
(Optional) To base the theme on an existing theme, select a color themes from the available themes.
4.
Click the Custom Color Theme disclosure button to show the Custom Color Theme panel.
Custom Color Theme Panel shows the color theme panels for both continuous and categorical themes (respectively).
Custom Color Theme Panel
5.
Click New to create a new theme.
A new color theme is created based on the selected color theme. A temporary name is assigned to the theme.
6.
Type a new name in place of the temporary label. On Windows, do not press ENTER. The window closes if you do so.
7.
To modify the color theme, do any of the following:
‒
To modify the gradient of continuous color, move the sliders left or right.
‒
To add more colors to the gradient, click the color bar to choose a color. A new slider is displayed under the color bar.
‒
To change the color of a slider, click on the slider to display the Color window and choose another color.
‒
To reverse the order of the colors on the gradient, click Reverse.
‒
To distribute the colors evenly on the gradient, click Space Evenly.
‒
To list the custom theme in the Sequential pane, select Sequential from the drop-list.
‒
To list the custom theme in the Diverging pane, select Diverging from the drop-list.
‒
To list the custom theme in the Chromatic pane, select Chromatic from the drop-list.
‒
To prevent a theme from appearing in lists of color themes, select Hidden.
‒
To remove a color from the color theme, click the color’s slider and drag the slider above or below the color bar.
‒
To discard your changes, click Cancel.
8.
Click Save to save the custom color theme.
The new custom color theme is appended to the contents of the selected pane.
9.
Click OK to close the color theme window.
Continuous and Categorical Color Themes
The following figure shows examples of the two types of color themes in JMP, continuous and categorical. When a color theme is selected for continuous data, the colors are graduated (as shown on the left). When the same color theme is selected for categorical data, the color consists of distinct blocks of color. (as shown on the right).
Examples of Continuous and Categorical Color Themes
Custom Color Themes
Custom color themes can be applied in the same way as built-in color themes:
•
You can select custom color themes as defaults from the Continuous Color Theme and Categorical Color Theme drop-down menus in the Graphs preferences. Only continuous color themes are available for continuous data. All color themes are available for categorical data.
•
You can apply the custom color themes to components such as markers and data table rows. See Assign Colors or Markers to Rows Based on Column Values for details.
•
In certain reports, such as treemaps and surface plots, you can select specific custom color themes. See the Basic Analysis book for details.
Use Custom Color Themes on Multiple Computers
In Windows, the color themes that you create are defined in the JMP preferences file called JMP.PFS. If you use JMP on more than one computer (for example, at home and at work), you can copy the color theme definitions from one JMP preferences file to another. Custom colors are then available on both computers.
In the preferences file, the code for a custom color theme looks like this:
Add Color Theme(
{"Pink to Blue", {{255, 168, 255}, {255, 0, 255}, {0, 128, 255}}}
),
In this example, the name of the color theme is “Pink to Blue.” The Red/Green/Blue (RGB) values for each color slider are located in brackets. The first slider defines the RGB values 255, 168, and 255. The second and third groups of brackets define colors for the second and third sliders.
In a text editor (such as Microsoft Notepad) add this color theme to the preferences file on your other computer. The preferences file is located in your Users folder within the JMP or JMPPro folder.
C:\Users\<user_name>\AppData\Roaming\SAS\JMP\<version_number>
C:\Users\<user_name>\AppData\Roaming\SAS\JMPPro\<version_number>
C:\Users\<user_name>\AppData\Roaming\SAS\JMPSW\<version_number>
Note: To see the preceding folders, you must configure Windows Explorer to show hidden files and folders. For details, refer to the Windows help.
To transfer color themes to another Windows computer
1.
On the computer that contains the customized JMP preferences, select File > New > Script.
The Script window appears.
2.
Type the following JSL function:
Show Preferences()
3.
Click the Run Script button .
Your customized preferences are written to the log.
4.
Select View > Log (or display the open log).
The custom color theme that you created appears, for example:
Add Color Theme(
{"Pink to Blue", {{255, 168, 255}, {255, 0, 255}, {0, 128, 255}}}
),
This definition might be in the middle of other customized preferences that appear in the log.
5.
Save the log as Log.jsl and open the file on the computer whose preferences you are updating.
6.
On the computer whose preferences you are updating, close JMP.
7.
Make a backup of JMP.PFS, and then open the original JMP.PFS in a text editor.
8.
Copy and paste the custom color definition from Log.jsl to JMP.PFS. The definition goes after Preferences( as shown in the following example:
Preferences(
Add Color Theme(
{"Pink to Blue", {{255, 168, 255}, {255, 0, 255}, {0, 128, 255}}}
),
);
Note: Be sure to include the closing parenthesis and comma. The code does not need to be indented. You can put the code in any valid location. Pasting it after Preferences( helps ensure that you do not delete any necessary parentheses or commas.
9.
Save the file.
If you open JMP and the new color definition is not displayed in the preferences, delete the updated preferences file and add the definition to the original preferences file. Make sure that you copy and paste the definition in the correct location.
Delete Custom Color Themes
1.
Select File > Preferences > Graphs.
2.
To either delete a color theme, select either the Continuous or Categorical Color Theme.
The relevant Color Themes window appears.
3.
Click the Custom Color Theme disclosure button to show the Custom Color Theme panel.
4.
From the appropriate pane, select the custom color to delete.
Note: You can delete only custom color themes.
5.
Click Delete.
6.
Click OK to save your changes and close the Color Themes window.
Delete Row Characteristics
To clear all row states in the data table, select Rows > Clear Row States. To clear row states only in selected rows, select Rows > Clear Selected Row States.
All rows become included, visible, unlabeled, and show in plots as black dots. The Clear Row States command does not affect row states saved in row state columns.
Lock Columns in Place
You can lock a column in place so that when you scroll horizontally, the column remains visible. Highlight the columns and select Cols > Scroll Lock/Unlock. Note the following:
•
Hidden columns cannot be scroll locked.
•
The name of a locked column appears in italics in the Columns panel.
•
Scroll locked columns are moved to the left in the data grid. Once you unlock them, they are not moved back to their original locations in the data table, but remain on the left.
•
Columns remain scroll locked until you highlight the columns and select Scroll Lock/Unlock again.