How to Show Difference Between Two Bars in Excel Graph

Comparing two bars on a chart seems simple, but a standard Excel chart only shows you the size of each bar, not the gap between them. To truly understand performance, you need to visualize the difference itself. This article will walk you through a few effective methods to create Excel charts that clearly highlight the difference between two data points.

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

Why a Standard Bar Chart Isn't Always Enough

Imagine you're looking at a Q1 vs. Q2 sales report for different product categories. A standard clustered bar chart is great for showing the total sales in each quarter. You can easily see that Product B sold more in Q2 than in Q1.

However, determining how much more requires your audience to squint at the axis, estimate the values, and do some quick mental math. This small bit of friction can distract from the main message of your analysis.

Clarity is king in data visualization. The goal is to make insights obvious at a glance. By visualizing the difference directly, you remove the guesswork and guide your audience straight to the key takeaways - like identifying the product with the largest growth or the one that saw the steepest decline.

Method 1: Use a Waterfall Chart for a Clear Story

The Waterfall chart is Excel’s built-in solution for showing how a starting value is affected by a series of positive and negative changes. It’s perfect for telling a "before and after" story, like comparing monthly revenue, and it automatically visualizes the increase or decrease without any complex formulas.

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-by-Step Guide to Creating a Waterfall Chart

Let’s use a simple dataset comparing January and February sales for three different ad campaigns.

1. Structure Your Data Correctly

Waterfall charts need a specific data structure. You'll need columns for your categories, the starting value (Jan), the change (Feb - Jan), and the ending value (Feb). Create a new "Change" column and calculate it using a simple subtraction formula.

• Column A: Campaign Name
• Column B: January Sales
• Column C: February Sales
• Column D: Change (Formula: =C2-B2)

Your table should look something like this:

We only need three columns to build the chart: Campaign, January Sales, and Change. We will add the February value back in later.

2. Insert the Waterfall Chart

Select the data for your first campaign - in this case, the labels "January Sales" and "Change" and their corresponding values (cells B1:B2 and D1:D2). We start with just one category to build the structure.

Go to the Insert tab, click the Waterfall, Funnel, Stock, Surface, or Radar chart icon, and select Waterfall.

3. Set the Start Bar as a "Total"

Your initial chart will treat "January Sales" as another change. We need to tell Excel it's the starting point.

• Click once on the "January Sales" bar to select the series, then click it a second time to select just that individual bar.
• Right-click the bar and choose "Format Data Point."
• In the pane that opens, check the box for "Set as total." The bar will change color (usually to gray or your theme's default) and sit firmly on the baseline.

4. Add a Final "Total" Column

To complete the visual story, we'll add a final bar representing February's sales total.

• In your data table, add a new row called "February Total" under your categories. In the Jan Sales column for this row, put a value of 0. In the Change column, input the total February sales value. You can use the formula =SUM(C2:C4).
• Resize your chart's data source to include this new row.
• Just like before, single-click the new "February Total" bar, right-click, and Set as total.

Now you have a chart that clearly shows your starting point for January, visually represents the growth or decline with a floating bar, and ends with the final February total. You can repeat this process for your other campaigns or represent the entire summary in one chart.

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

Method 2: Use Up/Down Bars on a Line Chart

This classic method is surprisingly effective and easy to implement. It works by creating a line chart with two data series (e.g., Q1 and Q2 sales) and then filling the space between the lines with colored bars that represent the difference.

Step-by-Step Guide to Using Up/Down Bars

1. Select Your Core Data

For this method, you only need the original data. Select the columns containing your categories (Product A, B, C) and your two values (Q1 Sales and Q2 Sales).

2. Insert a Line Chart

With your data selected, go to the Insert tab, click the Line or Area Chart icon, and choose the first Line with Markers option.

3. Add Up/Down Bars

This is the magic step. Make sure your chart is selected, and a Chart Design tab will appear in the ribbon.

• Click on the Chart Design tab.
• On the far left, click Add Chart Element.
• Hover over Up/Down Bars and select Up/Down Bars.

Instantly, Excel will fill the vertical gap between your two lines. The default colors typically show one color for increases (where Q2 is higher than Q1) and another for decreases.

4. Clean Up the Chart for Clarity

The chart now shows the difference, but the lines can be distracting. To focus entirely on the bars:

• Click on one of the lines to select that data series.
• In the Format Data Series pane on the right, go to the Fill & Line tab (the paint bucket icon).
• Under "Line," select "No line."
• Repeat this for the second line.

You can even remove the line markers by selecting "None" under the "Marker" options. You’re now left with beautifully clean, floating bars showing the exact difference between your two series.

Method 3: Create a Floating Column Effect with Helper Columns

This method is a bit more manual but offers a lot of control. The idea is to create a stacked column chart where the bottom part of the stack is invisible, creating a floating bar effect that represents the difference between your two values.

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-by-Step Guide for a Floating Column Chart

1. Add Two Helper Columns

Start with your original data. You'll need to create two new columns: a "Base" and a "Difference."

• Base Column: This will be the starting point of your floating bar. It should be the smaller of your two values. Use the MIN formula: =MIN(B2,C2).
• Difference Column: This will be the size of the floating bar itself. It's the absolute difference between your two values. Use the ABS formula: =ABS(C2-B2).

2. Create a Stacked Column Chart

Now, select only your categories (the campaign names) and your two new helper columns (Base and Difference). Hold the Ctrl key to select non-adjacent columns.

Go to the Insert tab and create a Stacked Column Chart.

3. Make the Base Series Invisible

The chart almost looks right, but we need to hide the bottom portion of each stack (the Base series).

• Click on any of the Base columns (usually the bottom blue part of the stack) to select the entire series.
• Right-click and select Format Data Series.
• Go to the Fill & Line tab.
• Under Fill, select "No fill."

That’s it! The base segments will disappear, leaving you with floating bars that clearly represent the difference between your original two values.

Quick Tips for Awesome Difference Charts

• Use Color Meaningfully: Assign distinct colors to increases and decreases. Green for positive and red for negative are universally understood.
• Clear Labeling: Give your chart a descriptive title, like "Monthly Sales Growth Per Product." Add data labels directly to the difference bars so values are easy to read.
• Keep it Simple: Remove unnecessary clutter like gridlines, borders, or 3D effects. The simpler the chart, the more powerful its message.
• Choose the Right Method: Use a Waterfall chart for start-to-finish stories. Use Up/Down Bars for trend comparisons over time. Use the Floating Column method for maximum design control.

Final Thoughts

Visualizing the difference between data points, rather than just the totals, takes your reports from merely showing data to actively explaining what it means. Using techniques like waterfall charts, up/down bars, or custom floating columns helps you tell a clearer and more impactful story with your Excel analysis.

While these methods in Excel work great, setting up helper columns and formatting charts still takes time. We built Graphed to streamline this entire process. Instead of manual steps, you can just ask in plain English, "Show the sales growth from January to February for each campaign," and get an interactive chart in seconds, connected directly to your live data.