Make Time Series Graph / Plot – Excel & Google Sheets

This tutorial demonstrates how to create a time series graph in Excel & Google Sheets.

Make Time Series Graph / Plot – Excel

We’ll start with the below data that shows how many clicks a website received per day. We want to show how to visualize this time series.

Starting Graph to Create Time Series Graph

 

Creating a Graph

  1. Highlight the time series data
  2. Select Insert
  3. Select Scatterplot
  4. Click on Scatter with Smooth Lines

Create Scatter with Smooth Lines Graph in Excel

 

Time Series Scatterplot Graph

You can see the graph that is made below

Time Series Scatterplot Graph in Excel

You can see the final time series graph after cleaning up the X and Y Axis.

Final Time Series Graph in Excel

 

Make Time Series Graph / Plot – Google Sheets

  1. Highlight data
  2. Select Insert
  3. Click Chart

Create Time Series Scatterplot Graph in Google Sheets

And your time series graph is created:

Final Time Series Graph in Google Sheets