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.
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.
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.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Comparing Lists of Values in Excel using Array Formulas||Register for our Excel & Financial Modeling Bootcamp in Singapore [Details inside] »|