How to Make a Win Loss Chart in Excel

Looking at a spreadsheet full of positive and negative numbers can feel like deciphering a code. A win-loss chart turns that code into a clear story, immediately showing you the ups and downs of your performance. This guide will walk you through exactly how to build one in Excel, transforming a simple data table into a powerful visual report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly is a Win-Loss Chart?

A win-loss chart, sometimes called a waterfall or bridge chart variation, is a visualization designed to represent positive and negative values over time or across categories. Conventionally, positive values (wins) are shown as bars going up from a central baseline, while negative values (losses) are shown as bars going down. This intuitive design provides an instant snapshot of performance against a benchmark, goal, or zero-line. Think of it as a visual scorecard. Are you consistently hitting your sales targets? A win-loss chart will show a series of green bars reaching upward. Did your marketing campaign's A/B test results flutter above and below expectations? The chart will capture that narrative perfectly, showcasing which variations won and which lost.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Benefits of Visualizing Wins and Losses

Moving your data from a raw table to a chart isn't just about making things look pretty. It's about clarity and speed of insight. Here’s why a win-loss chart is so effective:

• Instantly Spot Trends: It’s easy to see patterns at a glance. Are you experiencing a winning streak late in the quarter? Is there a consistent Q3 slump? This sort of trend recognition is much harder to spot when scanning a long column of numbers.
• Improve Clarity and Communication: This chart type is universally understood. "Up is good, down is bad." It’s a great way to communicate performance in team meetings or shareholder reports without needing to verbally explain every data point.
• Engage Your Audience: A strong visual can capture attention far more effectively than a dense spreadsheet. When you need to make a quick point about performance, a win-loss chart delivers immediate impact.
• Highlight Significant Events: A towering "win" bar or a deep "loss" bar naturally draws the eye, pointing directly to periods of exceptional success or significant challenges that may need further investigation.

Step 1: Preparing Your Data

The foundation of any great chart is well-structured data. For a win-loss chart in Excel, you can't just use a single column of numbers with both positive and negative values. You need to split them into two separate columns: one for wins and one for losses. This is the secret to getting Excel to color the bars differently. Let's use a common example: tracking a sales team's monthly variance from their quota. Our initial data might look like this:

• Column A: Month
• Column B: Actual Sales
• Column C: Sales Quota
• Column D: Variance (Calculated with the formula =B2-C2)

Creating Separate "Win" and "Loss" Columns

Now, we'll add two new helper columns. Column E will be "Wins" (for positive variance) and Column F will be "Losses" (for negative variance).

1. Set up the "Wins" column: In cell E2, enter the following formula: =IF(D2>0, D2, NA()) This formula tells Excel to do one of two things: if the value in D2 is greater than 0 (a win), display that value. Otherwise, display #N/A. Using NA() instead of 0 is critical - it tells Excel to leave a blank space on the chart, which is exactly what creates an empty spot rather than plotting a zero value at the axis.
2. Set up the "Losses" column: In cell F2, enter a similar formula for the losses: =IF(D2<0, D2, NA()) This checks if the variance in D2 is less than 0 (a loss), and if so, displays that negative value. Otherwise, it also returns #N/A.
3. Drag the formulas down: Click on the small square at the bottom right corner of cells E2 and F2 and drag it down to apply the formulas to the rest of your data.

Your data table should now look something like this, ready for charting:

Step 2: Creating the Win-Loss Chart

With the data perfectly structured, building the chart itself is a straightforward process.

1. Select Your Data

First, highlight your categories (in our case, the "Month" column). Then, while holding down the Ctrl key (or Cmd on a Mac), highlight your "Wins" and "Losses" columns. This technique allows you to select non-adjacent columns of data to be plotted.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Insert a Stacked Column Chart

Go to the Insert tab on Excel's ribbon. In the Charts section, click the Column Chart icon and select the Stacked Column chart. It might seem strange to choose a "stacked" chart since we want our bars to go in opposite directions, but this is the correct starting point. Excel will plot both the positive wins and negative losses from the same axis for now. You should now see a basic chart on your worksheet, though it won't look like a win-loss chart just yet. The wins will likely be stacked on top of an empty space (where the #N/A loss values are), and vice versa for the losses.

Step 3: Customizing Your Chart for Impact

A default Excel chart gets the data on the page, but some quick formatting changes are needed to turn it into a professional win-loss visual.

1. Adjust the Colors for Clarity

The core of a win-loss chart is the color scheme. It provides an immediate visual cue for performance.

• Click on one of the bars representing your "Wins" data series. All the bars in that series will be selected. Right-click and select a color Fill, something like green is standard practice.
• Next, click on one of the bars in your "Losses" data series. Repeat the process but change the color Fill to red.

2. Adjust The Bars' Gap Width

By default, column charts in Excel can have very thin bars with large gaps between them. For a more impactful visual, you can make the bars thicker.

• Right-click on either the green or red bars on your chart and select Format Data Series.
• A side panel will open, you're looking for an option called Gap Width.
• Decrease the percentage - a value around 50% usually works well. The bars will become wider, making the chart look and feel much more visually appealing.

Graphed

Still Building Reports Manually?

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

Watch the Demo

3. Polish the Chart Axes, Title, and Labels

Now it's just about cleaning everything else up!

• Give your chart a useful title: Something like "Monthly Sales Performance: Variance to Quota."
• Eliminate clutter: Consider removing gridlines if you feel it makes your chart look less organized.
• Adjust your Vertical Axis: The position of your horizontal axis is critical. To make sure it's in the center of your chart, right-click the vertical axis and choose Format Axis. Under Axis Options, look for where the Horizontal axis crosses. In the dialogue input, select 0 as a numerical custom value for your axes.

Beyond Sales: Other Ways to Use a Win-Loss Chart

While sales performance is a classic example, the win-loss chart is incredibly versatile. It's useful in any scenario where you're measuring performance against a target. Here are a few other ideas:

• Project Management: Track how many days a project is ahead of or behind schedule after each milestone. "Wins" are days ahead, and "losses" are days behind.
• Customer Support: Monitor ticket resolution times against a Service Level Agreement (SLA). Resolve a ticket 2 hours ahead of the SLA? That's a +2 win. Resolve one an hour late? That's a -1 loss.
• Personal Finance: Track your monthly budget. Did you come in $200 under budget (a win) or go $50 over (a loss)? This chart makes visualizing your saving and spending habits very easy.
• Manufacturing Quality Control: Track product output deviations from a target specification. Any output that is within spec is a marginal win and any outside is a clear and simple loss.

Final Thoughts

And there you have it. By structuring your data correctly with separate columns for positive and negative outcomes and formatting accordingly, you can create a clear and impactful win-loss chart in Excel, perfect for tracking your most critical key performance indicators at a granular level. While mastering Excel is an incredibly valuable skill, we believe that gaining key insights from your data shouldn't always involve manual data wrangling with formulas and format panes. This is why we've built Graphed. Using plain, conversational English, our AI-powered analytics tool builds live, interactive, real-time dashboards for your business in seconds, freeing you and your data analysts up to think and focus on acting on the data rather than manipulating spreadsheets or building time-consuming reports... the machine can do that from here on out.