How to Make a Time Graph in Google Sheets

A time graph is one of the most effective ways to see how a metric changes, whether you're tracking daily sales, monthly website traffic, or project progress. Google Sheets makes creating these graphs simple, turning rows of raw data into a clear visual story. This guide will walk you through setting up your data, building the chart, and customizing it to highlight key trends.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly is a Time Graph?

A time graph, often called a time series graph or a line chart, is a visual tool that plots data points in chronological order. The horizontal axis (the x-axis) always represents a period of time - like days, weeks, months, or years - while the vertical axis (the y-axis) represents the quantity or metric you're measuring.

You've seen them everywhere, used for things like:

• Marketing: Tracking website sessions, ad spend vs. conversions, or social media follower growth over a quarter.
• Sales: Visualizing daily revenue, number of deals closed per week, or tracking team performance against a monthly target.
• Operations: Monitoring inventory levels, tracking customer support tickets, or seeing project completion rates over time.

Their power lies in their simplicity. At a glance, you can immediately spot trends (Is revenue trending up or down?), patterns (Do sales consistently spike at the end of every month?), and anomalies (What caused that sudden drop in traffic last Tuesday?).

Step 1: Get Your Data Ready

The single most important step in creating an accurate time graph is formatting your data correctly. A messy spreadsheet will lead to a confusing chart. Luckily, the structure is straightforward.

Your data needs to be organized into two simple columns:

• Column 1: The Time Period. This column should contain your dates or timestamps. It's critical that Google Sheets recognizes these values as dates, not just as plain text.
• Column 2: The Metric. This column contains the numeric value you're tracking for each corresponding time period (e.g., sales, page views, items sold).

Let's use an example. Imagine you want to track the number of daily sessions on your website for the first two weeks of a month.

Your data would look like this:

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Ensure Your Dates are Formatted Correctly

If your graph isn't working as expected, it's almost always a date formatting issue. To check and fix this:

1. Select your entire date column (e.g., click on the 'A' at the top of column A).
2. Go to the menu and click Format > Number > Date.
3. This tells Google Sheets to interpret the content of these cells as chronological dates, which is essential for building an accurate timeline on your graph's x-axis.

Step 2: Create the Time Graph

With your data properly organized, creating the graph itself takes just a few clicks. Google Sheets is quite intelligent and will often guess the correct chart type for you.

1. Select Your Data Range

Click and drag your mouse to highlight all the cells containing your data, including the headers ("Date" and "Sessions" in our example).

2. Insert the Chart

With the data selected, navigate to the top menu and click Insert > Chart. A chart editor sidebar will pop up on the right side of your screen, and a default chart will appear on your sheet.

3. Choose the "Line Chart" type

Google Sheets usually defaults to a line chart for time-based data, but if it suggests something else (like a bar chart), you can easily change it. In the chart editor sidebar, under the Setup tab, find the "Chart type" dropdown menu and select Line chart.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

4. Check Your Axes Configuration

Under the "Setup" tab, Google Sheets splits your data into the X-axis and the Series (Y-axis):

• X-axis: Make sure your "Date" column is selected here. This creates the timeline.
• Series: Your "Sessions" column (or whatever metric you're tracking) should be listed here. This plots the values along the timeline.

If you're plotting weekly or monthly data instead of daily, you can look for the "Aggregate" checkbox. Ticking this box lets you group your dates directly within the chart, for example, summarizing daily data points into a weekly average line without having to create a separate pivot table.

Step 3: Customize Your Chart for Clarity

A default chart gets the job done, but a well-customized chart tells a much clearer story. The Customize tab in the chart editor is where you can refine its appearance.

Chart & Axis Titles

The first thing you should do is give your chart a descriptive title. Under Customize > Chart & axis titles, you can set:

• Chart title: Change "Sessions vs. Date" to something more descriptive, like "Daily Website Sessions: First Half of June 2024."
• Horizontal axis title: Add context by labeling it "Date."
• Vertical axis title: Label it with your metric, like "Number of Sessions."

Series Formatting

This section lets you change the look of the actual line on your graph.

• Color: Change the line's color to match your brand or to differentiate it from other lines if you add more data series.
• Line thickness: Make the line thicker for better visibility.
• Data points: Add circular or other shapes to mark each individual data point. This makes it easier to see the exact value for any given day.

Add a Trendline

A trendline is a fantastic tool for visualizing the overall direction of your data, smoothing out the daily ups and downs to show the big picture.

Here's how to add one:

1. In the Customize tab, go to the Series section.
2. Scroll down and check the box that says Trendline.
3. A dotted line will appear across your chart, showing whether your metric is generally increasing, decreasing, or staying flat over the period.

A trendline instantly answers the high-level question: "Are we moving in the right direction?" even if there's a lot of daily volatility.

Adjusting Gridlines and Ticks

Under Gridlines and ticks, you can control the background lines on your chart. Sometimes, the default gridlines are too busy. You can reduce the "Major gridline count" on the vertical axis to create a cleaner look or adjust the spacing on the horizontal axis ticks to better display dates.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Advanced Tip: Plotting Multiple Data Sets

What if you want to compare two different metrics over the same period? For instance, comparing Website Sessions vs. Sales on the same graph. To do this, simply add a third column to your data:

When you select all three columns and insert a chart, Google Sheets will automatically create a graph with two separate lines - one for "Sessions" and one for "Sales." You can then customize each line's color and style under the "Series" section in the Customize tab, and you can add a legend to clearly label what each line represents.

Final Thoughts

Creating a time graph in Google Sheets is a simple but powerful way to uncover insights hiding in your data. By structuring your information correctly and using the chart editor to your advantage, you can quickly build a clear visual that tracks performance and highlights important trends over any period.

Once you get the hang of it, you might find yourself building these reports regularly. Pulling data from tools like Google Analytics, Shopify, or your CRM and loading it into a spreadsheet can become a tedious weekly chore. That's why we designed Graphed to help. Instead of manually exporting CSVs, we connect directly to your marketing and sales platforms, allowing you to create real-time, self-updating dashboards just by asking questions in plain English - no more spreadsheet wrangling required.