fbpx
Search
Close this search box.

Win Loss Chart from a Series of Win, Loss Data

Share

Facebook
Twitter
LinkedIn

Last week, we learned how to create win-loss charts in Excel. In the comments, Dan said,

Incidentally, the fastest way to do this would be using SFE, just reflect your data with 1 for a win, – 1 for a loss. There’s even an option to automatically invert negative numbers. #

Of course, we can use the beautiful Sparklines for Excel addin to do this and several other charts. But if you just have a series of Wins and Losses, like below, you can use a column chart to create win loss charts too.

Your Data:

Lets say you have data like this,

Data for Win Loss Chart - Excel Win Loss Chart

 

Win Loss Chart in Excel – 5 Steps

Step1: Select Win & Loss columns and Insert a Column Chart

This is the first and easiest step. At the end, your chart looks like this:

Win Loss Column Chart - Step 1

Adjust Series Overlap and Gap - Winloss Chart in ExcelStep 2: Adjust the Series Gap & Overlap

  • Select either Win or Loss series and press CTRL+1 (or goto format series).
  • From here, adjust the gap to 0
  • and overlap to 75%, like shown aside.

Step 3: Remove un-necessary chart elements

  • Remove grid lines and labels
  • Remove horizontal axis
  • Select vertical axis and press CTRL+1 (format axis).
  • Now, adjust axis min to -1 and max to 1
  • Close it and remove vertical axis too

Step 4: Adjust colors

Change the colors if you fancy.

Step 5: That is all

There is no step 5. Your win loss chart is ready. Go ahead and show it off.

Win Loss Chart - Improved

Download Win Loss Chart (Improved) Template:

Click here to download the winloss chart template and play with it.

 

Click here to download the winloss chart template complete with Sinusoid chart template. (Supplied by Hui)

Learn more – Excel Charting

If you want to learn Excel Charts, start with our charting tutorials page. We have more than 250 articles on charting, visualization, data analysis and excel tips.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

5 Responses to “Win Loss Chart from a Series of Win, Loss Data”

  1. Raj says:

    Dear Dear Again can not open the excel version.

  2. Nik Birkin says:

    I use similar to the loss/win to graphically represent sales for departments - which is a win if above budgets a loss if less. It is very effective - draws attention to the weekly sales dashbaord on the Intranet.

  3. shaun says:

    I have never used this graphing concept before, but can see its application, especially to our hit rate of converted sales enquiries. One question that I have, is that I would like to combine this with some other form of graph to show the cumulative scores of both win and loss to make identification of overall win or loss and comparison with previous timeframes possible. I was thinking that area or bar graphs would be an option, but perhaps a more ambitious option would be to fit a sin area graph to the win loss graph to identify not only the cumulative scores but highlight winning or loss streaks.

  4. Hui... says:

    Shaun its quiet easy to add a small Sin Chart to the file
    Refer: https://rapidshare.com/files/346360712/Win-loss-new_with_Sin_Chart.xlsx
    The above includes the ability to change the frequency of days of the curve as well as the offset of a starting cycle.
    Enjoy
    Hui...

  5. shaun says:

    Thankyou so much for your response. I have emailed you a very basic drawing of what i was envisioning (please excuse the crude and inacurate method). I was wanting to use the crest of the sin wave to grow with the cumulative score of the wins/losses so as to represent the cumulative score in height of the sin graph and the win/loss streak would be represented by the width of the curve. Perhaps a sin graph is not the most appropriate tool, but having an idea of cumulative wins/losses and win loss streaks would enable comparison with historic timelines and perhaps help to identify seasonal trends through the win loss streaks.

Leave a Reply