Time-Series Plot

Overview | How to | Example

Overview

The Time Series Plot plots observations in the order of time.

How to

At the Excel Menu (For Excel 2007, go to Add-ins first)

1. Choose ProcessMA > Graphs > Time-Series Plot

2. In Variable, select the column containing the data (Numeric)

3. In Time Stamp, select the column containing time stamp data (Date)

4. Click OK

Example

You gathered sales data for the last 24 months. You want to use the Time Series Plot to see the performance for the past 24 months.

1. Open data worksheet by choosing ProcessMA > Tools > Data

2. Choose ProcessMA > Graphs > Time-Series Plot

3. In Variable, select Q - Revenue

4. In Time Stamp, select R - Month

5. Click OK

Results & Interpretation

Copyright © ProcessMA