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.
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