Win Loss Chart from a Series of Win, Loss Data

Posted on June 15th, 2011 in Charts and Graphs - 5 comments

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.

Written by Chandoo
Tags: , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

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