Create a time series plot of multiple Y variables

In the Time Series Plot dialog box, complete the following steps to specify the data for your graph. If your data are arranged differently than described below, go to Choose a time series plot.

  1. In Y variables, enter the columns of time-ordered numeric data that you want to graph.
  2. (Optional) In Time scale labels, you can specify a column of labels for the x-axis. The label column should contain one label value for each interval on the x-axis.
  3. Under Display, specify whether to display the variables as overlapping series (Start all at the same time) or as consecutive stages (Plot in consecutive stages).
Example for Start all at the same time

A technician counts the number of parts that are produced on two different machines each day and records the data in the columns Machine 1 and Machine 2. These columns are the Y variables. The technician also enters the dates in the Date labels column to use as the time scale labels.

Because each row represents the same day, the technician chooses Start all at the same time. The graph shows the number of parts that were produced on each machine each day.

C1 C2 C3
Machine 1 Machine 2 Date labels
5196 4367 May 22
4563 4100 May 23
4659 4451 May 24
... ... ...
Example for Plot in consecutive stages

A manager tracks the number of calls that sales representatives receive each day during two stages of an advertising campaign and records the data in the columns Stage 1 and Stage 2. These columns are the Y variables. The manager also enters the dates in the Date labels column to use as the time scale labels.

Because the stage 1 data was collected before stage 2 data, the manager chooses Plot in consecutive stages. The graph shows that the number of calls that were received each day during both phases of the campaign.

C1 C2 C3
Stage 1 Stage 2 Date labels
428 1462 Mar 23
1042 1032 Mar 24
1535 1171 Mar 25
... ... ...
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy