How to Make a Time Series Graph in Google Sheets

The easiest way to understand your data is to see it visually, and nothing tells a story about growth, decline, or trends quite like a graph that plots performance over time. A time series graph takes data points recorded at regular intervals - like daily sales, monthly website users, or quarterly revenue - and displays them in a way that makes patterns instantly clear. This guide will walk you through exactly how to prepare your data and build a clean, effective time series graph in Google Sheets.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What Exactly Is a Time Series Graph?

A time series graph (most often a line chart) is a simple but powerful tool that plots one variable against time. The horizontal axis (X-axis) always represents time intervals (days, weeks, months, years), while the vertical axis (Y-axis) represents the metric you are measuring (revenue, traffic, new customers, etc.).

Why is this format so useful? Because it helps you answer critical business questions at a glance:

• Identifying Trends: Are your sales steadily increasing over the last year? Is website traffic on a downward trend? A time series graph makes the long-term direction obvious.
• Spotting Seasonality: Do you see a consistent spike in sales every December? Does engagement drop every summer? Recognizing these seasonal patterns helps you plan inventory, marketing campaigns, and resources.
• Detecting Anomalies: A sudden, sharp drop or spike in your data will stand out immediately. This signals you to investigate what caused the change - perhaps a successful marketing campaign or a broken website link.

Essentially, it transforms a boring spreadsheet of numbers into a clear visual narrative of your performance over a specific period.

Preparing Your Data: The Most Important Step

Before you can create a graph, your data needs to be structured properly. Garbage in, garbage out. Google Sheets is smart, but it needs your data organized in a way it can understand. For a time series graph, a simple two-column format is best.

The Ideal Data Structure

Set up your spreadsheet with two columns:

• Column A: The Time Component. This column should contain your dates or time periods. These could be specific dates (e.g., 01/01/2024), months (e.g., Jan-24), or years (e.g., 2024).
• Column B: The Metric. This column holds the numerical data you want to plot over time, like daily sales revenue, monthly users, or weekly leads.

Here’s an example of a perfectly structured dataset for tracking monthly website users:

Example Data:

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Formatting Dates Correctly

One of the most common issues people face is incorrect date formatting. If Google Sheets doesn't recognize your "Month" column as a date, it will treat it as simple text, which can lead to your graph plotting things in the wrong order or not at all.

To fix this, highlight your entire date column, go to the menu, and select Format > Number > Date. You can choose any date format you prefer, but this step tells Google Sheets to interpret the data correctly as a sequence in time.

Pro Tip: Be consistent! Make sure all your dates are in the same format. Avoid mixing formats like "Jan 1," "2/1/2024," and "March 1st, 2024" in the same column.

Step-by-Step: How to Make a Time Series Graph in Google Sheets

Once your data is clean and organized, creating the chart takes less than a minute. Let’s use our website user data from the example above.

Step 1: Select Your Data

Click and drag your mouse to highlight the cells containing your data, including the headers ("Month" and "Website Users"). Including the headers helps Google Sheets automatically label your chart's axes.

Step 2: Insert the Chart

With your data selected, navigate to the top menu and click Insert > Chart. Google Sheets will automatically create what it thinks is the best chart for your data. In most cases, it will correctly guess that a line chart is what you need for time series analysis.

Step 3: Choose the Right Chart Type (If Needed)

If Google Sheets didn’t select a line chart, you can easily change it. The Chart editor sidebar will appear on the right side of your screen. Under the "Setup" tab, find the "Chart type" dropdown menu and select Line chart. Immediately, you’ll see your data plotted over time.

And that’s it! You have now created a basic time series graph.

Customizing Your Graph for Maximum Clarity

A basic chart is good, but a well-customized chart is great. A few small tweaks can make your graph much easier to read and understand. In the Chart editor, click over to the "Customize" tab.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

1. Add Informative Titles

Your chart needs a clear, descriptive title. Under Chart & axis titles, you can edit the Chart title, Horizontal axis title, and Vertical axis title.

• Chart Title: Change the generic "Website Users vs. Month" to something more descriptive like "Monthly Website Users (First Half 2024)."
• Axis Titles: While often clear from the data, it's good practice to label your axes. "Month" for the horizontal axis and "Number of Users" for the vertical axis leaves no room for confusion.

2. Adjust the Line and Points

Under the Series section, you can change the appearance of your line. You can modify the line color to match your brand, change its thickness to make it bolder, and add points or shapes to mark each data point. This can make the individual data points easier to see, especially if the line is long.

3. Add a Trendline to See the Bigger Picture

One of the most powerful features for time series analysis is the trendline. Still in the Series section, scroll down and check the box for Trendline. Google Sheets will automatically overlay a line that shows the general direction of your data. This is an incredibly simple way to instantly confirm an upward or downward trend, cutting through the noise of monthly fluctuations.

4. Tweak the Gridlines and Ticks

Under the Gridlines and ticks section, you can adjust the vertical axis to better fit your data. For example, if your traffic never drops below 10,000, you can set the minimum value of your vertical axis to 10,000. This magnifies the variations in your data, making the changes from month to month more pronounced and easier to analyze.

Advanced Time Series Techniques

Ready to go beyond a single line? Here are a couple of powerful ways to create more sophisticated time series graphs in Google Sheets.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Comparing Multiple Data Series

What if you want to compare website traffic from two different sources, like Organic Search and Social Media, over time? This is easy to do. Just add another column for your second metric.

Example Data:

Now, select all three columns and click Insert > Chart. Google Sheets will automatically plot two separate lines on the same graph, one for each data series. Under the Customize > Legend section, you can choose where to place the legend (e.g., at the top or bottom) so your audience knows which line is which.

Using a Combo Chart for Different Scales

Imagine you want to compare your monthly ad spend (a few hundred or thousand dollars) with your website sessions (tens of thousands). Plotting these on the same axis would make one line look completely flat. The solution is a Combo Chart.

First, create your chart as usual with three columns (Date, Ad Spend, Sessions). Then, in the Chart editor...

1. Under "Setup," change the Chart type to Combo chart.
2. Under "Customize," open the Series dropdown.
3. Select the series you want to move to a different axis (e.g., Ad Spend).
4. In the "Axis" dropdown for that series, choose Right axis.

This creates a second vertical axis on the right side of the chart scaled specifically for your Ad Spend data. Now you can easily see the relationship between two metrics of completely different magnitudes.

Final Thoughts

Mastering the time series graph in Google Sheets is a fundamental skill for anyone who works with data. By properly organizing your data, choosing a line chart, and adding smart customizations like titles and trendlines, you can transform static numbers into dynamic insights that show where your business has been and where it might be going.

While Google Sheets is fantastic for manual analysis, the process of exporting CSVs from your various data sources and wrangling them into the right format every week can quickly become a chore. We built Graphed to eliminate this pain by connecting directly to your tools like Google Analytics, Shopify, and your ad platforms. Instead of building charts by hand, you can just ask a question like, "Show me my Shopify revenue versus my Facebook ad spend last quarter as a line chart," and get a live, real-time dashboard in seconds.