Graph a subset of data

You can graph a subset (or portion) of the data in the worksheet, without altering the worksheet itself. For example, if data contain outliers, you can omit these potentially distracting points from your graph without deleting them.
Scatterplot with outlier
Scatterplot with outlier excluded
Note

Minitab automatically rescales the graph based on the subset of data points you specified.

To specify a subset of data to use when you create a graph, click Data Options. On the Subset tab, select whether to include or exclude the specified observations on your graph.

Specify the rows to include or exclude
Rows that match a condition
Include or exclude rows that match the condition that you specify. Click Condition and enter the formula. For more information, go to Create a formula with the Calculator.

For example, if C1 contains dates and you want to exclude rows that contain dates between 1/3/2016 and 1/7/2016, enter C1>Date("1/3/2016") and C1<Date("1/7/2016").

Brushed rows
Include or exclude rows that are currently brushed (usually outliers).
Row numbers
Enter the row numbers to include or exclude. Use a colon (:) to denote an inclusive range. For example, enter 1 4 6:10 to signify the rows 1, 4, 6, 7, 8, 9, 10. Use a slash (/) to denote increments. For example, enter 1:30/2 to signify all the odd number rows from 1 to 29.
Leave gaps for excluded points
If you are creating a time series plot or a control chart, you can select this option to leave a space in the graph for the points that you exclude.

For control charts, Minitab treats the excluded points as missing values in the calculations for control limits. If you don't select this option, then Minitab omits the entire rows that contain excluded points from the calculations for control limits.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy