How to Do a Growth Trend in Excel

Displaying your business growth in Excel is more than just plotting numbers on a line chart. To make smart decisions, you need to see the underlying trend, calculate the rate of that growth, and even forecast where you're heading. This guide will walk you through three practical methods in Excel to move beyond simple charts and perform a meaningful growth trend analysis.

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 Growth Trend?

A growth trend is simply the general direction of your data over a period. Is your monthly revenue generally going up, staying flat, or declining? That's your trend. Understanding this is crucial for a few key reasons:

• Performance evaluation: It tells you if your strategies are working. A positive trend in sales after a new marketing campaign is a clear signal of success.
• Forecasting: By understanding your historical trend, you can make educated guesses about future performance, helping with inventory planning, budgeting, and goal setting.
• Problem spotting: A flattening or declining trend can be an early warning sign, prompting you to investigate a potential issue before it becomes a major problem.

Whether you're tracking monthly website sessions, new subscribers, or product sales, analyzing the growth trend helps turn your raw data into actionable business intelligence.

First Things First: Prepare Your Data

Before you can analyze anything, your data needs to be clean, organized, and properly formatted. Following these simple setup rules will prevent most common Excel errors and make your analysis much smoother.

Your data should be organized in two columns at a minimum:

1. A Time Period column (e.g., Day, Week, Month, Quarter).
2. A Metric column with the numeric value you want to track (e.g., Sales, Users, Clicks).

Here are the non-negotiable rules for setting up your table:

• Keep it clean: One header row, followed by your data. No merged cells or empty rows in the middle of your dataset.
• Chronological order is a must: Your time periods should be sorted from oldest to newest.
• Consistent time intervals: Make sure your time periods are consistent (e.g., all are months, all are weeks). Mixing daily data with monthly data will distort your trend.
• Check your formatting: Right-click the column header and select "Format Cells." Make sure your dates are formatted as Date, and your metrics are formatted as Number or Currency. This is critical for Excel’s functions to work correctly.

A clean dataset should look something like this:

Method 1: Visualize Your Growth with a Trendline

The fastest way to understand your data’s direction is to see it. A line chart with a trendline instantly shows you the big picture. This is a great starting point for any growth analysis.

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

Step 1: Create a Line Chart

A line chart is the ideal choice for visualizing data over time. Select your entire data table (including the headers), navigate to the Insert tab on the Ribbon, and select the first 2-D Line chart option.

Your chart should appear instantly.

Step 2: Add the Trendline

Now, let's add the trendline to reveal the underlying growth pattern.

1. Click on the chart to bring up the Chart Design tab.
2. On the far left, click Add Chart Element.
3. Hover over Trendline and select Linear.

‘Linear’ assumes your growth is happening at a relatively steady rate, which is a good baseline for most business metrics. A solid line will now appear over your data, showing the overall trend.

Step 3: Display the R-squared Value for Confidence

How much can you trust this trendline? The R-squared value tells you. It’s a statistical measure (from 0 to 1) of how closely your actual data points fit the trendline.

1. Right-click on the trendline itself and select Format Trendline. A sidebar will open.
2. Scroll to the bottom of the options and check the box that says Display R-squared value on chart.

An R² value close to 1 (e.g., 0.95) means the trendline is a very accurate representation of your data. A low value (e.g., 0.3) suggests your data is volatile and the linear trend isn't a reliable fit.

Method 2: Calculate Month-over-Month (MoM) Growth Rate

A trendline shows you the general direction, but sometimes you need the specific numbers. Calculating the period-over-period growth rate tells you the exact percentage change from one month to the next.

Step 1: Add a "Growth Rate" Column

In the column next to your sales data (Column C, in our example), add a header called MoM Growth.

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

Step 2: Enter the Growth Formula

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

You can't calculate growth for the first month since there's no previous period, so we’ll start our formula in the second data row (cell C3).

Assuming your sales data is in column B, click on cell C3 and enter this formula:

=(B3-B2)/B2

Step 3: Format and Fill Down

Press Enter. The result will likely show up as a decimal. Select column C, go to the Home tab, and click the percent style button (%) to format it as a percentage.

Now, click on cell C3, grab the small square handle in the bottom-right corner (the fill handle), and drag it down to the last row of your data. This automatically copies the formula, adjusting the cell references for each row.

You now have a clear view of your monthly growth fluctuations, showing high-growth months and periods of decline.

Method 3: Forecast Future Growth with the FORECAST Function

Analyzing historical data is useful, but what if you want to project future performance? Excel’s FORECAST.LINEAR function does exactly that by extending your linear trendline into the future.

Step 1: Set Up Your Future Time Periods

First, you need to tell Excel which future period(s) you want to predict. In your Month column, add the next few months you want to forecast below your existing data.

Step 2: Understand and Use the FORECAST.LINEAR Function

The function’s syntax looks like this:

=FORECAST.LINEAR(x, known_y's, known_x's)

That might seem intimidating, but it’s quite simple:

• x: The new month you want to forecast a value for.
• known_y's: Your range of existing historical sales data.
• known_x's: Your range of existing historical month data.

Let's say our historical months are in A2:A13, and our historical sales are in B2:B13. We've added our first future month, Jan-25, in cell A14.

In cell B14, right next to Jan-25, you would enter the following formula:

=INT(FORECAST.LINEAR(A14, $B$2:$B$13, $A$2:$A$13))

Note on the dollar signs ($) and INT:

• The dollar signs lock the known_y's and known_x's ranges. This is critical because you always want the formula to reference your original historical data, even when you drag the formula down.
• The INT() function wrapped around the formula simply rounds the result down to the nearest whole number, which is useful for metrics like sales or users where decimals don't make sense.

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

Step 3: Drag Down to Populate Your Forecast

Press Enter, then drag the fill handle down from B14 to populate the forecasts for the other future months you added. Excel will calculate the projected sales for each period based on your historical trend.

You can even add this new forecasted data back into your original line chart to see your historical trend and future projection all in one place!

A quick word of caution: Remember that this is a linear forecast. It assumes the conditions that created your past growth will continue unchanged. It's a fantastic baseline projection but doesn't account for seasonality, market changes, or one-off events.

Final Thoughts

Mastering these Excel techniques - visualizing with trendlines, calculating growth rates, and projecting with the FORECAST function - gives you three powerful ways to analyze your business's performance. You can move beyond raw numbers and begin to build a data-informed strategy based on historical patterns and future potential.

While Excel is endlessly powerful, keeping up with this process can be a chore. Manually downloading CSVs, cleaning them up, and refreshing your charts and formulas week after week takes time away from acting on the insights. We built Graphed to solve this very problem. By connecting your live data sources just once, it allows you to ask for a trend analysis, a growth forecast, or a real-time dashboard using simple language, completely automating the grunt work of reporting, and letting you focus on the results.