How to Make a Revenue Chart in Excel

Creating a revenue chart in Excel is one of the most effective ways to understand your business performance at a glance. Instead of getting lost in rows of numbers, a chart tells a visual story, making it easy to spot trends, compare time periods, and communicate results to your team. This tutorial will walk you through exactly how to build several types of essential revenue charts in Excel, step-by-step.

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

Setting Up Your Revenue Data for Charting

Before you can make a chart, your data needs to be clean and organized. The better your data structure, the easier it will be for Excel to create an accurate chart. Aim for a simple, tabular format.

For a basic revenue report, you'll want at least two columns:

• Date: The day, week, or month the revenue was recorded. Make sure these are formatted as dates in Excel (right-click -> Format Cells -> Date).
• Revenue: The total revenue for that period. Be sure this is formatted as currency (right-click -> Format Cells -> Currency).

Here’s an example of a simple data set showing monthly revenue:

Pro Tip: Turn your data range into an official Excel Table. Click anywhere within your data, go to the Insert tab, and click Table. This makes your chart dynamic - when you add a new row of data to your table, your chart will update automatically!

How to Make a Monthly Revenue Line Chart

The line chart is perfect for showing trends over time. It's the go-to chart for tracking metrics like revenue, website traffic, or sales on a continuous basis. Let's build one with our sample data.

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: Select Your Data

Click and drag to highlight all the cells containing your data, including the headers ("Month" and "Revenue").

Step 2: Insert the Line Chart

Navigate to the Insert tab on Excel's ribbon. In the Charts section, find the Line or Area Chart icon (it looks like a small line graph). Click on it and select the first option under 2-D Line, which is a simple line chart with markers.

Excel will instantly generate the chart and place it on your worksheet. It automatically uses your 'Month' column for the horizontal axis (X-axis) and the 'Revenue' column for the vertical axis (Y-axis).

Step 3: Customize Your Chart for a Professional Look

A default chart gets the point across, but a few tweaks can make it much clearer and more professional. Click on your chart to activate the "Chart Design" and "Format" tabs in the ribbon.

Here are some essential customizations:

• Give it a clear title: Double-click the default "Chart Title" and type something descriptive, like "Monthly Revenue - 2024."
• Add Axis Titles: Click the plus sign (+) next to your chart and check the box for "Axis Titles." Double-click the new labels to rename them to "Month" and "Revenue ($)."
• Format the Y-Axis as currency: Right-click on the numbers on the vertical axis (the revenue values), choose Format Axis.... In the pane that opens to the right, scroll down to Number, select "Currency" from the category dropdown, and change the decimal places to 0 for a cleaner look.
• Add a Trendline: Click the plus sign (+) again and check the box for Trendline. This adds a dotted line showing the general direction of your revenue, which is a great way to visualize your growth trajectory at a glance.

After these adjustments, you have a clean, easy-to-read chart that clearly tells the story of your revenue growth over time.

Creating Other Useful Revenue Charts

While a line chart is great for time-series data, other chart types are better for answering different business questions. Let's look at a few common examples.

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

1. Column Chart: Comparing Revenue by Category

What if you want to see which product or service categories generate the most revenue? A column chart (or bar chart) is perfect for comparing values across different categories.

First, you'll need to summarize your data. The best way to do this is with a PivotTable.

Suppose you have more detailed data, like this:

• Create a PivotTable: Select your detailed data, go to Insert, and click PivotTable. Excel will open a new sheet with the PivotTable builder on the right.
• Arrange the Fields: Drag "Product Category" into the Rows area and "Revenue" into the Values area. This will instantly give you an aggregated summary of total revenue per category.
• Insert a PivotChart: With your cursor on the PivotTable, go to the PivotTable Analyze tab and click PivotChart. Choose a Clustered Column chart and click OK.

This creates a chart showing your top-performing categories, making it obvious where your revenue is coming from.

2. Pie Chart: Showing Revenue Contribution

A pie chart works well when you want to show parts of a whole, such as how each category contributes to your total revenue.

Using the same PivotTable from the previous step:

• Click on your existing PivotChart to select it.
• Go to the Chart Design tab.
• Click Change Chart Type.
• Select Pie from the list and click OK.

To make it even more useful, click the plus sign (+) next to the chart and add Data Labels. You can even format these labels to show percentages, giving an instant view of each category's share of the total revenue.

Quick tip: Pie charts are best when you have 5 or fewer categories. Any more and it becomes cluttered and hard to read.

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. Combo Chart: Monthly Revenue vs. Goal

A combination chart is fantastic for comparing two different types of data, like your actual monthly revenue against your monthly goal.

First, set up your data with three columns: Month, Actual Revenue, and Revenue Goal.

• Select all three columns of your data.
• Go to Insert -> Recommended Charts, and choose the Clustered Column chart.
• This will create a chart with two bars for each month. Right-click on one of the bars representing the "Revenue Goal" series, and click Change Series Chart Type....
• In the dialog that appears, change the chart type for "Revenue Goal" from a Clustered Column to a Line. Click OK.

Now you have a dynamic combo chart that visualizes your performance against your target each month, showing both actuals and goals in one clear view.

Best Practices to Keep in Mind

• Don't overcomplicate it. The goal is clarity. Avoid 3-D effects, shadows, or excessive colors that distract from the main message.
• Use color with purpose. Use contrasting colors for different data series, and maintain brand consistency if the chart is for an external presentation.
• Label everything clearly. Make sure your chart title, axis titles, and data labels are descriptive enough that anyone can understand the chart without having to ask for an explanation.
• Choose the right chart for the job. Use line charts for trends over time, bar/column charts for comparisons between categories, and pie charts to show composition.

Final Thoughts

Visualizing your revenue doesn't have to be intimidating. By structuring your data properly and using the right chart type, you can turn a lifeless spreadsheet into a powerful tool for understanding your business and making better decisions. Mastering these techniques in Excel gives you the ability to tell a clear and compelling story with your numbers.

Creating these charts in Excel is powerful, but it's often a manual, time-consuming weekly ritual. You have to download the latest CSV files from Shopify, Google Analytics, or your ad platforms, clean them up, and update your charts. At Graphed, we built a tool to eliminate this entire process. By connecting your data sources directly, you can simply ask in plain English - like "Show me a chart of my Shopify revenue by month" - and instantly get a live dashboard that updates automatically.