Hide Rows

Apply the Hidden row state to rows that you do not want to include in subsequent plots. The plots that are updated when you Hide rows are updated immediately.

Note: Not all plots hide the elements that correspond to hidden rows. This is often the case when the calculations used to construct the plot elements use the data from the hidden rows. As a general rule, if there is a one-to-one correspondence between rows and plot elements, the points or elements corresponding to the hidden rows are hidden.

Note the following:

•

Hiding rows does not exclude them from calculations and analyses. In particular, plots that are constructed using observations use the data from hidden rows unless those rows are also excluded.

•

In most cases, plot elements that are calculated using observations are not updated to reflect hidden observations unless those rows are also excluded.

•

When each hidden row corresponds to a point or an individual plot element, plots are updated immediately when you apply the Hidden row state to rows.

•

For some plots where plot elements correspond to groups of rows, when you Hide rows, the plot is updated to hide plot elements corresponding to hidden rows. See Plots Where Grouping Elements are Updated for Hide.

•

When you Hide rows, they are hidden in all open plots that are updated immediately.

•

When you Hide rows, a mask icon (

) appears beside the row number.

•

Rows remain hidden until you highlight the rows and select Hide/Unhide again.

To hide one or more rows

Select rows that you want to hide.

Do one of the following:

–

Right-click on the highlighted area next to the row numbers and select Hide/Unhide.

–

From the Rows menu, select Hide/Unhide.

Plots Where Grouping Elements are Updated for Hide

When you apply Hide to rows, in plots with a one-to-one correspondence between rows and plot elements, the points or plot elements are usually hidden immediately. However, for the following platforms and options, applying Hide results in immediate updates to plot elements that correspond to groups of rows:

•

Control Chart Builder. See Control Chart Builder in the Quality and Process Methods book for details.

•

Graph Builder. The Bar chart, Heat Map, and Pie chart are updated to reflect hidden rows. See Graph Builder in the Essential Graphing book for details.

•

Bubble Plot. See Bubble Plots in the Essential Graphing book for details.