How to Make a Growth Chart in Google Sheets

Tracking your key metrics over time is how you know if your business is actually moving in the right direction. Google Sheets is an incredible tool for this, but staring at rows of numbers can make it hard to see the big picture. This guide will walk you through exactly how to create a clear and insightful growth chart, calculate period-over-period performance, and customize it all to tell a compelling story about your progress.

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 is a Growth Chart? (And Why You Need One)

A growth chart is simply a visual representation of how a specific metric changes over time. Whether it’s monthly sales, weekly website traffic, or daily user signups, a growth chart transforms raw data into an intuitive story. Instead of scanning a column of figures, you can see the narrative at a glance.

Why bother? Because a good growth chart helps you:

• Spot Trends Instantly: Is your growth accelerating, slowing down, or hitting a plateau? A chart makes the answer obvious in a way that numbers alone can't.
• Understand Momentum: Seeing a visual upward curve is far more motivating and telling than comparing two numbers. It helps you understand the velocity of your business.
• Make Better Decisions: Did your new marketing campaign in March cause a spike in signups? A chart can help you connect actions to outcomes.
• Communicate Progress: Showing a chart to your team or stakeholders is infinitely more effective than presenting a spreadsheet. It makes performance easy to understand for everyone, technical or not.

Ultimately, a growth chart is less about just plotting data and more about understanding the story behind it.

Getting Your Data Ready for Charting

This is the most important step. A chart is only as clear and accurate as the data that powers it. Messy data leads to a confusing chart. The good news is that for a simple growth chart, your data structure should be just as simple.

For best results, organize your spreadsheet with two basic columns:

1. A "Time Period" column: This contains your dates, listed sequentially. This could be days, weeks, months, or quarters. Make sure these are formatted consistently.
2. A "Metric" column: This is the number you want to track. Keep the headers clear and simple, like "Revenue," "Sessions," or "New Subscribers."

Here’s what a properly set up dataset looks like. Nice, clean, and ready to go.

Example Data Setup:

Keep it this simple. Avoid adding multiple metrics in the same column or including summary rows (like "Total") within your data range, as this can confuse Google Sheets when it tries to generate a chart.

Creating Your First Growth Chart: A Step-by-Step Guide

With your data prepped, creating the initial chart takes less than a minute. Let’s walk through the steps.

1. Select Your Data

Click and drag your cursor to highlight the cells that contain your data, including the headers. In our example, you’d select the cells from "Month" down to the last revenue figure.

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

2. Insert the Chart

With your data selected, navigate to the main menu and click Insert > Chart. Google Sheets will automatically analyze your data and suggest a chart type it thinks is best. More often than not, it will suggest a line or column chart, which are perfect for tracking growth.

3. Choose the Right Chart Type

The Chart editor will pop up on the right side of your screen. Under the "Setup" tab, you'll see a dropdown for "Chart type." While Google’s suggestion is often good, you can manually choose the best fit:

• A Line Chart is the best option for showcasing a continuous trend over time. It makes it easy to see the flow and momentum of your metric.
• A Column Chart (or Bar Chart) is great for comparing discrete values for each time period. It puts more emphasis on the magnitude of the metric each month rather than the continuous trend.

For most growth tracking, a line chart is the fan favorite. Let's stick with that for this example.

At this point, you have a basic growth chart! It shows your core metric on the Y-axis (the vertical one) and the time period on the X-axis (the horizontal one). But we can make this much more insightful.

Calculating and Plotting Year-over-Year (YoY) Growth

Seeing the raw number for your metric is good, but understanding its rate of growth is even better. Calculating the period-over-period growth rate adds a crucial layer of context. For this example, let's say your data is monthly YoY but the principles would be the same Month-over-Month (MoM) or another time period.

We're going to add a new column to our sheet that calculates this growth percentage for us automatically.

1. Add a "Growth Rate" Column

In the column right next to your "Revenue" data (Column C), add a new header called "YoY Growth."

2. Enter the Growth Formula

The formula for calculating the growth rate is: (Current Period - Previous Period) / Previous Period.

You can’t calculate growth for the very first period (since there’s no "previous" data to compare it to), so you’ll start your formula in the second data row. Let's assume your revenue numbers are in column B, starting at cell B2.

In cell C3, you would type this formula:

=(B3-B2)/B2

Press Enter. You'll see a decimal number. Now, click on cell C3 again and drag the small blue square (the fill handle) at the bottom-right corner downwards. This will automatically copy the formula to the rest of the rows in your "YoY Growth" column, adjusting the cell references as it goes.

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

3. Format as a Percentage

Your growth column is currently showing decimals. To make it readable, highlight the entire "YoY Growth" column, go to the toolbar, and click the Percent (%) icon. Now your growth rate is clearly displayed.

Your data should now look something like this:

Creating a Combo Chart for Total Clarity

Now for the fun part: showing both your raw revenue and your growth rate on the same chart. This provides a complete picture, displaying not just the total amount but also the velocity of its growth.

A "Combo Chart" is perfect for this, as it allows you to represent different data series with different chart styles (e.g., columns for revenue, a line for growth).

1. Update the Chart's Data Range

Double-click your existing chart to open the Chart editor. Under the "Setup" tab, click on the grid icon next to the "Data range." Adjust the range to include your new "YoY Growth" column (e.g., A1:C13).

The chart will now try to plot both revenue and growth, but it will look messy. That's because the scales are completely different - revenue is in the thousands, while growth is a tiny percentage. We'll fix this in the next step.

2. Switch to a Combo Chart Type

Still in the Chart editor, change the "Chart type" to Combo chart.

Now your revenue will be shown as columns and your growth rate as a line. It's an improvement, but the growth rate line will likely look flat against the bottom of the chart because its values (e.g., 0.06 for 6%) are so small compared to the revenue values (e.g., 10,500).

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

3. Add a Right Axis

This is the magic touch that makes combo charts work. By moving the Growth Rate series to its own axis on the right side of the chart, you allow it to have its own scale.

• In the Chart editor, switch to the "Customize" tab.
• Click on the "Series" dropdown.
• First, make sure the "Revenue" series is set to "Columns".
• Next, in the same dropdown, select your "YoY Growth" series.
• Below, you'll see an "Axis" option. Change it from "Left axis" to "Right axis."

Instantly, your chart becomes readable! The columns use the left axis for revenue amounts, and the line uses the right axis for growth percentages.

Customizing Your Chart for Impact

A functional chart is great, but a polished chart is professional. Spend a few minutes on customization to make your insights impossible to ignore.

Clear Titles and Axis Labels

Under Customize > Chart & axis titles, give your chart a descriptive title, like "Monthly Revenue and YoY Growth Rate." Then, give your axes proper labels, like "Revenue ($)" for the Left vertical axis and "Growth %" for the Right vertical axis.

Colors and Line Styles

Under Customize > Series, you can change the color and style of your columns and lines. Make the revenue bars a solid brand color and the growth line a contrasting, vibrant color to make it pop.

Adding Data Labels

To show the exact values on the chart, click on any series (e.g., your columns). In the customization options, check the box for "Data labels". This adds the exact numbers on top of each column or next to each point on the line, saving your audience from having to guess.

Final Thoughts

Building a growth chart in Google Sheets takes your company's data and turns it into a potent story about business momentum. By visualizing your performance and layering in period-over-period growth rates, you unlock the ability to quickly see trends, communicate achievements, and guide your strategy with real data, not just feelings.

We know that even with a guide, manually exporting CSVs and wrestling with chart settings every week can be a drag. We built Graphed because we believe getting these critical insights should be much easier. Once you connect your apps, you can just ask in plain English, "Show me a combo chart of monthly sessions and MoM growth this year," and a live, professional dashboard appears in seconds. It allows you to skip straight to analysis and spend your time acting on data, not just organizing it.