How to Plot a Time Series in Excel (With Example)

This tutorial provides a step-by-step example of how to plot the following time series in Excel:

Let’s jump in!

Step 1: Enter the Time Series Data

First, let’s enter the following values for a time series dataset in Excel:

Step 2: Plot the Time Series

Next, highlight the values in the range A2:B20:

Then click the Insert tab along the top ribbon, then click the icon called Scatter with Smooth Lines and Markers within the Charts group:

The following chart will automatically appear:

The x-axis shows the date and the y-axis shows the sales.

Step 3: Customize the Time Series Plot

Lastly, we can customize the plot to make it easier to read.

Double click any of the values on the x-axis. In the Format Axis panel that appears, click the icon called Size & Properties and type -45 in the box titled Custom angle:

The x-axis labels will be rotated at a 45 degree angle to make them easier to read:

Lastly, click on the Chart Title and change it to whatever you’d like.

Then click the labels on each axis and make them bold:

The time series plot is now complete.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Add Labels to Scatterplot Points in Excel
How to Change Axis Scales in Excel Plots
How to Add a Vertical Line to Charts in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *