A subset is a portion of the data in the worksheet. Some Minitab functions, including many graphs and charts, let you define a subset of data in order to work with it in isolation without changing the data in the worksheet itself. For example, your worksheet may contain data for the entire year, but you want to create a time series plot of only the previous six months. Using the subset option lets you graph only those data points that came after your specified date.

When you create a graph, you can specify a subset of data to graph.

- In the dialog box for the graph you are creating, click Data Options, then click the Subset tab.
- Specify whether to include or exclude rows from the graph.
- Specify which rows to include or exclude:
- Rows that match a calculator-defined condition; for example,
`Sum > 5`,`'Color' = 'Red'`, or`'Incident' >= DATE("1/1/13")`. Click Condition, and then enter the condition. - Rows that are brushed in another graph.
- Specific row numbers. Enter the row numbers.

- Rows that match a calculator-defined condition; for example,
- Click OK.

You have the following data in a worksheet and you would like to create a time series plot that includes only the data from 1/2/2014 to 1/7/2014 on the time series plot.

C1 | C2 |
---|---|

Date | Data |

1/1/2014 | 5 |

1/2/2014 | 6 |

1/3/2014 | 9 |

1/4/2014 | 8 |

1/5/2014 | 7 |

1/6/2014 | 8 |

1/7/2014 | 9 |

1/8/2014 | 10 |

1/9/2014 | 11 |

- Choose .
- In Series, enter
`C2`. - Click Data Options.
- Under Include or Exclude, choose Specify which rows to include.
- Under Specify Which Rows to Include, choose Rows that match and click Condition.
- In Condition, enter
`C1>=Date("1/2/2014") and C1<=Date("1/7/2014")`. - Click OK in each dialog box.