How to Make a Line Graph on Google Spreadsheet

Tracking changes over time is fundamental to understanding your business, and a line graph is one of the clearest ways to visualize that story. Whether you're monitoring website traffic, sales figures, or ad campaign performance, a well-made line graph can instantly reveal trends, patterns, and outliers. This guide will walk you through exactly how to create and customize stunning line graphs in Google Sheets, step by step.

Graphed

Still Building Reports Manually?

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

Watch the Demo

When Should You Use a Line Graph?

Before diving into the "how," let's quickly cover the "when." Line graphs are the perfect choice when your goal is to show a continuous data series over a specific time interval. The connected points along the line make it easy to see the flow of your data - is it trending up, down, or staying flat?

Think about using a line graph to answer questions like:

• How did our website sessions change month-over-month last year?
• What was our daily sales revenue during the Black Friday campaign?
• How has our customer churn rate trended over the last four quarters?
• Which of our three Facebook ad campaigns is generating the most leads over time?

Each of these scenarios involves measuring a specific metric (sessions, revenue, churn, leads) against a time period (months, days, quarters). If you're trying to compare categories that don't have a time component, like sales by product category for a single month, a bar chart might be a better fit. And if you're showing parts of a whole, like the percentage of traffic from different sources, a pie chart is usually the go-to.

Getting Your Data Ready for Graphing

The foundation of any good chart is clean, well-structured data. For a line graph in Google Sheets, you need a setup that is simple and logical. Messy data leads to a confusing graph, so a few moments of prep work here will save you a lot of headaches.

At a minimum, your spreadsheet should have two columns:

• Column 1 (The X-Axis): This column represents your time intervals. It should contain your dates, months, weeks, years, or quarters. It's important to list these chronologically so the line graph flows correctly from left to right.
• Column 2 (The Y-Axis): This column contains the numerical data you want to measure. These are the values that will determine the height of each point on your line graph, like sales totals, user counts, or conversion rates.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Example Data Structure

Imagine you want to track your website’s new users each month for the first half of the year. Your data in Google Sheets should look clean and simple, like this:

If you wanted to compare two different metrics, like new users vs. returning users, you’d simply add another column:

Notice that each column has a clear header ("Month," "New Users"). Including headers is a best practice, as Google Sheets will automatically use them as labels in your chart.

Step-by-Step: Creating a Basic Line Graph

With your data organized, creating the graph itself takes just a few clicks. We'll use the two-column "New Users" example from above.

Step 1: Select Your Data Range Click on the header of your first column (cell A1 in our example), hold down the Shift key, and click on the last data point in your second column (cell B7). This will highlight all the data you want to include in your chart, including the headers.

Step 2: Insert the Chart With the data selected, navigate to the menu at the top of the screen and click Insert > Chart. Google Sheets will instantly analyze your data and create a chart for you inside a new floating window.

Step 3: Choose the Line Graph Type Google Sheets is smart and often defaults to the best chart type for your data. In this case, it will likely select a line chart automatically. If it doesn't, or if you want a different style, you can easily change it. In the Chart editor pane that appears on the right, find the "Chart type" dropdown under the "Setup" tab. Click it and select "Line chart" from the list of options.

That's it! You now have a functional line graph embedded in your spreadsheet.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Making Your Line Graph Look Great: Customization Tips

A basic chart gets the job done, but a customized, well-labeled chart tells a much clearer story. The "Chart editor" in Google Sheets is where you can polish your graph to make it professional and easy to read. If you've closed the editor, just double-click on your chart to bring it back.

Improving Titles and Axis Labels

Generic titles don't provide much context. Let's make ours more descriptive.

1. In the Chart editor, click on the Customize tab.
2. Click on the Chart & axis titles section.
3. Under "Title text," change the generic title to something specific, like "Monthly New Users (First Half of the Year)."
4. You can also add titles for your horizontal (X-axis) and vertical (Y-axis) axes here. For the Vertical axis title, you could add "Number of Users" to make it explicit what the numbers represent.

Adjusting Colors and Line Style

You can change the look and feel of the line itself to match your branding or make it stand out.

1. In the Customize tab, go to the Series section.
2. Here you can change the line color, its opacity, and its thickness. A slightly thicker line can often improve readability.
3. You can also add markers for each data point by changing the "Point size" from "None" to a specific pixel value (e.g., 7px). This puts a clear dot on the line for each month's data point.

Working with Multiple Data Lines

If you're using our second data example (comparing New Users vs. Returning Users), Google Sheets will automatically create two lines on the same graph with a helpful legend. The Series section is where you can customize them independently. Use the dropdown selector at the top of the Series section to switch between customizing "New Users" and "Returning Users." It's a good practice to use distinct colors (e.g., a cool blue for new users and a warm orange for returning users) to make them instantly distinguishable.

Customizing the Gridlines and Scale

Fine-tuning the background of your chart can also dramatically improve clarity.

1. In the Customize tab, select Gridlines and Ticks.
2. Here, you can modify the gridlines on the vertical axis. You can change their color to be less prominent (like a light gray) or adjust the spacing by changing the "Major step" value if the default spacing feels too crowded or too sparse.
3. Under the Vertical axis section, you can also set a custom "Min" and "Max" value. This is useful if your data doesn't start near zero. For example, if all your values are between 8,000 and 15,000, setting the minimum value to 7,000 can make the fluctuations in the line appear more pronounced and easier to analyze.

Advanced Line Graph Techniques

Once you've mastered the basics, here are a couple of more advanced features you can use to extract even more insight from your data.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Adding a Trendline

A trendline is a straight line that overlays your graph to show the general direction of your data. It's incredibly useful for quickly identifying if your metrics are growing, declining, or holding steady over the long term, evening out any short-term fluctuations.

To add one:

1. Go to the Customize > Series section of the Chart editor.
2. Scroll down and check the box for Trendline.
3. A linear trendline will appear immediately. You can customize its type (Linear, Exponential, etc.), color, and thickness to make it stand out.

Creating a Combination Chart

Sometimes you need to visualize two very different types of data on the same chart. For example, you might want to show monthly revenue (in dollars) as columns and user growth (a percentage) as a line. A combination chart makes this possible.

1. Start with your data selected and go to Insert > Chart.
2. In the Chart editor, under the "Setup" tab, choose the "Combo chart" from the "Chart type" dropdown.
3. Go to Customize > Series. Here, you'll see a dropdown that lets you assign each data series to either the Left or Right axis. You can set your Revenue series to display as Columns on the Left axis and your User Growth series to display as a Line on the Right axis.

This creates a sophisticated visualization that tells a much richer story by showing how two different metrics relate to each other over time.

Final Thoughts

Creating a line graph in Google Sheets is a direct way to turn rows of numbers into a clear, actionable story about your performance over time. By preparing your data properly and using the customization options, you can create professional reports that effectively highlight key trends and inform better business decisions.

While mastering spreadsheets is a valuable skill, the process of manually exporting data, cleaning it up, and building charts can be incredibly time-consuming, especially as your data sources multiply. At Graphed , we automate this entire workflow. We connect directly to your tools like Google Analytics, Shopify, and your CRM, so your data is always live and in one place. You can build real-time dashboards and get answers just by asking questions in plain English - no manual data wrangling required.