How to Make a Growth Chart in Excel

Tracking your progress visually is a powerful way to understand performance, whether you're looking at sales figures, website traffic, or project milestones. A list of numbers can be draining to look at, but a chart can tell a story at a single glance. This guide will walk you through exactly how to create a growth chart in Excel, starting with a basic line chart and moving on to a more advanced combo chart to tell an even richer story.

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 Is It Useful?

A growth chart is a visual representation of how a specific metric changes over a period of time. It trades cluttered rows of data for a clear, intuitive line that shows trends, patterns, and progress toward your goals. Seeing a line going up creates a much stronger sense of momentum than reading a column of increasing numbers.

You can use a growth chart to track just about anything that can be measured over time:

• Business Metrics: Monthly revenue, quarterly sales, new customers per week.
• Marketing Performance: Website visitors, social media followers, newsletter subscribers.
• Operational Data: Customer support tickets resolved, units produced per day.
• Personal Goals: Money saved each month, pages read per week.

The main benefit is clarity. An Excel growth chart makes it easy to spot trends instantly. Are your sales consistently climbing, or are there seasonal dips you need to plan for? Is your website traffic growing faster this quarter than last? This visual context is invaluable for making informed decisions, creating reports, and presenting your progress to team members or stakeholders.

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

Step 1: Get Your Data Ready in Excel

Before you can make a chart, you need clean, well-organized data. This is arguably the most important step in the entire process. A great chart can't fix messy data.

Organize Your Data in Two Columns

For a basic growth chart, all you need are two columns. It's best practice to keep them side-by-side with clear headers.

• Column 1 (The X-Axis): Your Time Period. This should contain your time increments in chronological order (e.g., January, February, March, or Q1, Q2, Q3).
• Column 2 (The Y-Axis): Your Metric. This column should have the corresponding numerical value you want to track (e.g., Sales, Visitors, New Subscribers).

Here’s what your simple data set might look like for tracking monthly Shopify sales:

Make sure your time periods are consistent (e.g., all months or all quarters) and your metric data is formatted as numbers.

Calculate the Growth Rate (Optional but Powerful)

Sometimes, seeing the raw numbers isn’t enough. You might want to visualize the percentage of growth from one period to the next. Adding a "Growth Rate" column gives you another layer of insight.

The formula for period-over-period growth is: (Current Period - Previous Period) ÷ Previous Period

To add this to your spreadsheet:

1. Create a new column header called "Growth Rate".
2. Leave the first cell in this column blank, since you can't calculate growth for the first period (there's no previous period to compare it to).
3. In the second data row (for February in our example), click on the cell (C3 in our example) and enter a formula. If your sales numbers are in column B, your formula would be:

=(B3-B2)/B2

1. Hit Enter. Excel will give you a decimal number. To make it a percentage, select the cell, go to the Home tab, and click the percent sign (%) in the 'Number' section.
2. To apply this formula to the rest of your column, click on the cell with the formula (C3) and drag the small green square in the bottom-right corner (the fill handle) down to the end of your data. Excel will automatically adjust the formula for each row.

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

Step 2: Create a Basic Line Chart to Show Growth

Once your data is ready, creating the actual chart takes only a few clicks. We'll start with a simple line chart using our first two columns (Month and Sales).

1. Select your data. Click and drag your mouse to highlight the cells containing your time periods and your metric, including the headers (e.g., cells A1 through B7).
2. Navigate to the Insert tab on the Excel ribbon at the top of the screen.
3. In the Charts group, click on the icon called "Insert Line or Area Chart." A dropdown menu will appear.
4. Choose "Line with Markers." This type is ideal because the line shows the trend, and the markers pinpoint the exact value for each time period.

Excel will instantly generate a chart right on your spreadsheet. You have your growth chart!

Step 3: Customize Your Chart to Tell a Clear Story

Excel's default chart is a great start, but a few quick adjustments can make it much more professional and easier to understand for anyone who looks at it.

Add a Chart Title and Axis Labels

A chart without labels is just a picture. Giving it context is critical.

• Chart Title: Your chart will likely have a generic title like "Chart Title." Simply click on it and type a more descriptive name, like "2023 Monthly Sales Performance."
• Axis Labels: To add labels for your horizontal (X) and vertical (Y) axes, click anywhere on your chart to make the chart tools appear. Click the green plus '+' icon that shows up on the top right. Check the box for "Axis Titles." Two text boxes will appear on your chart. Click on each one to label them "Month" (for the X-axis) and "Sales Revenue ($)" (for the Y-axis).

Fine-Tune Your Chart’s Appearance

With the basics covered, you can add a few more touches to make your data pop.

• Change Styles and Colors: With your chart selected, the "Chart Design" tab appears in the ribbon. Here you can explore different pre-set styles and color palettes to match your brand's look or your presentation's theme.
• Add Data Labels: Want to see the exact sales number for each point on the line? Click the green '+' icon again and check the box for "Data Labels." This places the value directly on the chart, so your audience doesn’t have to guess.
• Add a Trendline: A trendline is a straight line that shows the general direction your data is moving. To add one, click the green '+' icon, hover over "Trendline," and click it. This is a powerful way to show overall positive or negative movement, even if there are small fluctuations from month to month.

Going Further: Create a Combo Chart to Show Growth and Growth Rate

What if you want to see both your total sales and the percentage growth rate on the same chart? This is where a combo chart comes in. It’s an advanced technique that allows you to plot two different data series that have very different scales (like large dollar amounts and small percentages).

Here’s how to build it:

1. Select all three columns created in Step 1: "Month," "Sales," and "Growth Rate."
2. Go to the Insert tab, but this time click "Recommended Charts."
3. In the pop-up window, click on the "All Charts" tab at the top.
4. On the left-hand navigation list, select "Combo" at the very bottom.
5. Now you'll see a customization area for your data series. Set it up as follows:
6. Click OK.

Your combo chart will appear. From here, you can customize it just like you did with the line chart. Don't forget to use the green ‘+’ icon to add an Axis Title for the new secondary axis on the right, labeling it "Growth Rate (%)" to ensure your chart is perfectly clear to anyone who views it.

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

Final Thoughts

Building a growth chart in Excel is a vital skill that transforms raw data into a meaningful story of your progress. By organizing your data correctly and using Excel’s charting tools, you can create a clear visual narrative that helps you and your team make better, more insightful decisions.

While creating charts in Excel is useful, the repetitive process of exporting data from different platforms, cleaning it up in spreadsheets, and manually rebuilding reports every week can consume hours of your time. We built Graphed because we believe your time is better spent acting on insights, not just gathering them. Instead of manual exports, just connect data sources like Shopify or Google Analytics directly, and then use plain English to ask for the chart or dashboard you need. Graphed builds a live, auto-updating dashboard for you in seconds, so you're always looking at real-time performance without any busywork.