How to Create a Comparison Graph in Excel

Comparing data is the first step to finding meaningful insights, and nothing does the job better than a well-designed chart. An effective comparison graph can instantly show you which products are a hit, which marketing channels are superstars, and where your performance is heading. This tutorial will walk you through exactly how to create a variety of powerful comparison graphs in Excel.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First, Prepare Your Data

Before you can build any chart, your data needs to be organized properly. Great charts start with clean data. Trying to create a graph from a messy collection of cells is a recipe for frustration and confusing visuals. The best structure for most comparison charts is a simple table with headers.

Your labels for comparison (e.g., product names, months, marketing channels) should be in the first column or top row. The corresponding values you want to compare should be in the columns or rows next to them.

For example, to compare product sales across different quarters, your data should look like this:

With clean data like this, Excel can easily understand the relationships between your categories and values, making the chart creation process smooth and simple.

Choosing the Right Comparison Graph

Excel offers several chart types that work well for comparisons. The one you choose depends on what story you're trying to tell with your data. Let's look at the most common types and how to create them.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Clustered Column or Bar Charts

These are the workhorses of data comparison. They use rectangular bars or columns to show the size of different data points, making it incredibly easy to see which values are higher or lower at a glance.

• When to use them: Use a column chart (vertical bars) when comparing items over a period of time, like monthly sales by product. Use a bar chart (horizontal bars) when comparing a set of categories, especially if the category names are long.

How to Create a Clustered Column Chart

Let's use our sample sales data to create a chart that compares quarterly sales for each product.

1. Select your data: Drag your cursor to highlight your entire data table, including the headers. In our case, highlight everything from "Product" to "$12,500".
2. Go to the Insert Tab: In the top ribbon, click on Insert.
3. Choose the Column Chart: In the Charts group, click the icon that looks like a column chart. A dropdown menu will appear.
4. Select "Clustered Column": In the 2-D Column section, choose the first option, which is Clustered Column.

Voilá! Excel will instantly generate a column chart. Each product will be represented by a group of columns, with each column in the group showing the sales for a different quarter. It's an excellent way to see both how individual products perform and how they stack up against each other over time.

Stacked Column or Bar Charts

Stacked charts are another variation of bar and column charts. Instead of placing the bars side-by-side, they stack them on top of one another. This gives you two types of insight at once.

• When to use them: Use a stacked chart when you want to compare the total for each category and also see the proportional contribution of each sub-category. For example, you could compare total website traffic each month and see the breakdown of that traffic (Organic, Social, Direct) within each month's total bar.

How to Create a Stacked Column Chart

Imagine your data shows website traffic sources for the last three months:

1. Select your data: Highlight the table, including headers.
2. Go to the Insert Tab: Click Insert in the ribbon.
3. Choose the Column Chart: Click the column chart icon again.
4. Select "Stacked Column": In the 2-D Column section, choose the second option, Stacked Column.

Excel will create a chart with three columns, one for each month. Each column will be segmented by color, showing how much traffic in that month came from Organic, Direct, and Social sources. This allows you to easily compare not just the totals but also the changing mix of traffic sources month over month.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Line Charts

Line charts connect a series of data points with a line, making them the absolute best choice for showing trends over a continuous period, like time.

• When to use them: Use a line chart to compare how two or more series change over time. It's perfect for tracking stock prices, website user trends, or monthly profits for different business lines.

How to Create a Line Chart

Let's go back to our product sales data. A line chart is another excellent way to visualize this information, focusing on the sales trends of each product.

1. Select your data: Highlight the sales and product table once more.
2. Go to the Insert Tab: Click Insert.
3. Choose the Line Chart: In the Charts group, click the icon that looks like a line graph.
4. Select "Line with Markers": In the 2-D Line section, the best choice for this type of data is usually Line with Markers. The markers will indicate the actual data points for each quarter.

You’ll get a chart with three separate lines, one for each product. This visualization makes it easy to spot trends. For instance, you could immediately see that sales for the "Alpha Widget" are on a steady incline, while the "Beta Gadget" had a small dip in Q3.

Radar Charts

Also known as spider charts, these are best for comparing multiple different characteristics across several items. Think of it like comparing "stats" for different players or products.

• When to use them: Use a radar chart to compare performance scores for different products across categories like "Price," "Features," "Customer Support," and "Ease of Use."

How to Create a Radar Chart

Your data needs to be structured with the categories in the first column and the items you're comparing in the headers. Each item should have a score for each category.

1. Select your data: Highlight the full table.
2. Go to the Insert Tab: Click Insert.
3. Find the Radar Chart: The radar chart icon isn't as prominent. Click the icon for Waterfall, Funnel, Stock, Surface, or Radar Chart.
4. Select "Radar": From the dropdown options, choose Radar.

This creates a spiderweb-like graph where you can immediately see which product has a better "shape," demonstrating its strengths and weaknesses across all categories at once.

Pro Tips for Effective Comparison Graphs

Creating the chart is only half the battle. Customizing it for clarity will multiply its impact.

Graphed

Still Building Reports Manually?

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

Watch the Demo

1. Always Add Clear Titles and Labels

A chart without labels is just abstract art. You need to tell your audience what they're looking at. Click on the chart, and a plus sign ("Chart Elements") will appear in the top-right corner. Use it to add:

• Chart Title: Be descriptive. Instead of "Sales," use "Quarterly Sales Performance by Product."
• Axis Titles: Label your X and Y axes. For a sales chart, the vertical axis might be "Sales (in USD)" and the horizontal axis "Fiscal Quarter."
• Data Labels: Sometimes it helps to show the exact value on each bar or point. Use this carefully so as not to clutter the chart.

2. Use Color Intentionally

Don't be a slave to Excel's default blue, orange, and gray theme. Color is a powerful tool for comparison.

• Brand Colors: Use your company's brand colors to make the chart feel cohesive with other reporting.
• Highlight One Thing: If you want to draw attention to your product's performance versus competitors, make your product's line or bar a bright, attention-grabbing color and gray out the competitors'.
• Contrasting Colors: Ensure the colors you choose are distinct and easy for everyone to tell apart.

3. Don’t Overcrowd the Chart

Simplicity is your friend. It can be tempting to put ten different products on a single line chart, but this almost always results in a confusing "spaghetti graph" that no one can interpret. If you have too many categories to compare, it's often better to split them into a few smaller, more focused charts.

Final Thoughts

Mastering comparison graphs in Excel transforms your data from a simple list of numbers into a powerful visual story. By preparing your data, choosing the right chart like a column, bar, or line chart, and adding clear finishing touches, you can create compelling reports that drive smarter decisions.

Of course, while building visuals in Excel is a fundamental skill, the process of exporting data from various sources and then manually creating and updating these charts can become quite a drag. At Graphed, we’ve automated this entire process. You simply connect your platforms like Google Analytics or Shopify, and create real-time, professional dashboards just by describing what you want to see. This turns hours of spreadsheet work into a 30-second task, so you can spend less time building charts and more time acting on the insights they provide.