Win Loss Chart from a Series of Win, Loss Data

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,

 

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:

Step 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.

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.

Generated by BlogIt

BlogIt - Auto Blogging Software for YOU!