How to Make a Time Series Plot

Tracking your website traffic, monthly sales, or ad performance over time is fundamental to understanding your business. A time series plot is one of the most powerful and straightforward ways to do exactly that. This article will show you what a time series plot is, why it's so helpful, and walk you through how to create one step-by-step using tools you already have.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly Is a Time Series Plot?

A time series plot, often just called a line chart, is a graph that shows data points collected or recorded at specific time intervals. Think of it as a story about your data, where the sequence of events is the most important part of the narrative.

Every time series plot has two main components:

• The Horizontal Axis (X-axis): This always represents time. The intervals can be seconds, days, weeks, months, or even years, depending on what you're measuring.
• The Vertical Axis (Y-axis): This represents the value of the metric you are tracking at each point in time, such as revenue in dollars, number of website visitors, or click-through rate.

For example, imagine you run an e-commerce store and want to track your daily sales for the month of December. You'd place the days (Dec 1, Dec 2, Dec 3...) along the x-axis and the corresponding sales amount for each day along the y-axis. Connecting these points with a line creates a time series plot. A quick glance would likely show you spikes on weekends and a massive jump closer to the holidays, patterns that are critical for planning inventory and marketing.

Why You Should Use Time Series Plots

Time series plots are more than just pretty pictures, they are essential diagnostic tools for any business. They turn raw, chronological data into clear, actionable understanding. Here’s why they’re so valuable.

Spotting Trends

The most immediate benefit of a time series plot is its ability to reveal trends. By looking at the overall direction of the line, you can instantly see if a metric is heading up, trending down, or staying relatively flat. Are your monthly recurring revenue (MRR) figures on a steady incline? Is user engagement on your app slowly dipping? The plot makes this obvious, helping you confirm if your strategies are working or if you need to course-correct.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Identifying Seasonality and Patterns

Many businesses have cyclical or seasonal patterns. A gym, for example, might see new memberships soar every January and then trail off. An online retailer might see sales spike every year during Black Friday. A time series plot visualizes these predictable cycles. Once you understand them, you can prepare for them - by ramping up ad spend during peak seasons or launching retention campaigns during expected lulls.

Detecting Anomalies and Outliers

An anomaly is a sudden, unexpected spike or dip in your data. It’s a break from the norm. A time series plot makes these stand out immediately. Did you see a huge, unexpected surge in website traffic on a random Wednesday? Your plot will show this as a sharp peak. This prompts you to investigate the "why." Perhaps a blog post got mentioned by a major influencer, or maybe a server issue caused a data tracking error. Either way, the plot is your first alert system.

Making Better Forecasts

By understanding past trends, seasonal effects, and regular patterns, you can make much more informed predictions about the future. While not a crystal ball, a time series plot provides a logical basis for forecasting. If you know sales have grown by an average of 10% for the last three quarters, it's reasonable to project similar growth for the next one, assuming conditions remain stable.

How to Create a Time Series Plot in Google Sheets (and Excel)

The great news is you don't need a PhD in statistics or a fancy, expensive tool to create a time series plot. You can easily make one in Google Sheets or Microsoft Excel. The process is nearly identical for both applications.

Let's walk through it using an example of tracking weekly user signups for a SaaS platform.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Prepare Your Data

The foundation of any good chart is clean, well-structured data. For a time series plot, you need at least two columns:

• Column A: The timestamp (e.g., Date, Week, Month)
• Column B: The metric you're measuring (e.g., User Signups, Revenue, Sessions)

Make sure your dates are in a consistent format (like MM/DD/YYYY). Google Sheets and Excel are smart, but they can get confused by mixed formats. Your data should look something like this:

Week Starting, New Signups 01/01/2024, 150 01/08/2024, 165 01/15/2024, 158 01/22/2024, 180 ...and so on.

Pro Tip: Ensure there are no empty rows in the middle of your data, as this can sometimes confuse the chart-making tool.

Step 2: Select Your Data

Click on the header of your first column (e.g., "Week Starting") and drag your cursor over to select all the data in both columns, including the headers. Don't just select the numbers, including the headers tells the software what to label the axes.

Step 3: Insert the Chart

With your data highlighted, navigate to the menu bar.

• In Google Sheets, click Insert > Chart.
• In Microsoft Excel, click the Insert tab and look for the Charts section, then select Line chart.

Almost like magic, the application will analyze your data and — recognizing the chronological format — will likely suggest a line chart by default. If it doesn't, you can select "Line chart" from the Chart Editor options that appear on the right side of your screen.

Step 4: Customize Your Plot for Clarity

A default chart is good, but a customized one is great. A few small tweaks can make your plot much easier to read and understand.

• Add a Descriptive Title: Change the generic "New Signups vs. Week Starting" to something specific and useful, like "Weekly New User Signups - Q1 2024."
• Label Your Axes: Often, the software gets this right, but double-check that your axes are clearly labeled. Your x-axis should say "Week" or "Date," and your y-axis should represent your metric, such as "Number of Signups."
• Add a Trendline: A trendline is a straight line that best shows the overall direction of your data, cutting through the weekly ups and downs. In the Google Sheets Chart Editor, go to Customize > Series and check the box for "Trendline." This gives you an immediate visual cue about your long-term growth trajectory.
• Plotting Multiple Series: What if you want to compare two metrics over time, like organic signups vs. paid signups? Simply add a third column for your second metric. Select all three columns of data before you insert the chart, and the software will automatically create two lines on the same plot, giving you a powerful comparison view.

Tips for More Effective Time Series Plots

Creating the plot is just the first step. Here are a few professional tips to make your analysis more insightful.

Choose the Right Time Granularity

The time interval you choose can completely change the story your data tells. Daily data is great for spotting short-term fluctuations but can be "noisy," making it hard to see a clear trend. If you plotted five years of sales data by day, the chart would be an unreadable scribble. In such cases, aggregating the data into weeks or months smooths out the noise and makes the underlying trend much clearer.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Use a Moving Average to See the Real Trend

If your daily or weekly data is very volatile, a moving average is your best friend. A "7-day moving average," for instance, takes the average of the last 7 days of data for each point. This smooths out random one-day spikes and dips, revealing the true underlying pattern.

In a new column next to your data, you can easily calculate it in your spreadsheet. If your daily signups are in column B starting at B2, the formula in a new column would be:

=AVERAGE(B2:B8)

You can then drag this formula down the column and add this "Moving Average" series to your chart. The resulting line will be much smoother and easier to interpret.

Annotate Your Chart to Add Context

Your plot shows you what happened, but annotations explain why. If you see a big spike in signups, it wasn't random. Add a note or a comment directly on the chart to mark key events. Things like "Launched new ad campaign," "Featured on major blog," or "Website redesign went live" add crucial context. This transforms your chart from a simple data graphic into a compelling business story.

Final Thoughts

Time series plots are a deceptively simple yet incredibly powerful tool. They help you visualize the story of your business over time, enabling you to identify trends, understand patterns, and make smarter decisions based on historical data rather than just gut feelings. Mastering this one chart type is a huge step toward becoming more data-driven.

Creating these plots in a spreadsheet is a fantastic skill, but we know the manual work of exporting data, cleaning it, and updating the same charts week after week can become tedious. We built Graphed to eliminate that friction. We connect directly to live data sources like Google Analytics, Shopify, and your ad platforms, so your dashboards are always up-to-date automatically. You can just ask for what you need in plain English - "show me a line chart of my ad spend vs. revenue in the last 60 days" - and Graphed builds the real-time plot for you in seconds.