You can create a plot of a time series divided into consecutive groups.

To create a time series plot of consecutive groups, you must use a worksheet that contains one column of time series data and at least one column of categorical grouping values where categories are consecutive.

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

Sales | AdAgency |

210 | Alpha |

205 | Alpha |

202 | Alpha |

... | .... |

368 | Omega |

358 | Omega |

346 | Omega |

... | ... |

- Choose .
- Choose With Groups, then click OK.
- In Series, enter a column of time series data. In the example, Sales is the series.
- Under Categorical variables for grouping (1-3), enter one or more columns of categorical data with categories entered consecutively. In the example, AdAgency is the categorical variable for grouping.
- To specify a time scale for the x-axis, click Time/Scale and choose the scale elements. In the example, the time scale is Calendar: Month.
- Click OK in each dialog box.