5.4 Time Series

The following steps will guide you to build a time series for displaying your data. Use the asset’s Close prices to build the time series.

  1. Select all cells in both Days and Close columns.

Note: If the columns with Days and Close prices are not adjacent (separate), first select the cells in one column, and then while holding the Control key on MAC (Control or CTRL on PC), select the cells in the other column.

  1. Click Insert > Scatter > Scatter with Straight Lines and Markers.
A screenshot of the chart options.

Figure 5.3: Scatter options in the Insert tab.

The resulting graph needed to be adjusted.

  1. Select the chart created.
  2. Replace the Chart Title with an appropriate title for your time series. This depends on your data set.
  3. With the graph selected, go to the Chart Design tab.
  4. To add axis titles, click Add Chart Element > Axis Titles > Primary Horizontal and then Add Chart Element > Axis Titles > Primary Vertical.
  5. Replace the Y-axis Title with an appropriate name for the vertical axis.
  6. Replace the X-axis Title with the word Day.
A screenshot of the adjustment options for the chart.

Figure 5.4: Chart adjustment options Chart Design.

  1. Make any adjustments necessary to the chart’s vertical and horizontal axes by RIGHT-clicking on them and selecting Format Axis.
A screenshot of the Format Axis options.

Figure 5.5: Chart adjustment of the horizontal axis.