Win Loss Chart provides a quick way of visualizing a series of data at one glance, with the help of Win Loss chart in excel one can easily represent the positive or negative polarity through Spark lines.
The data that we will be using to create Win Loss Chart in Excel are
Week1 | Week2 | Week3 | Week4 | |
---|---|---|---|---|
January | 7% | -3% | -1% | -8% |
February | -2% | 9% | -5% | -9% |
March | 2% | 5% | 10% | 3% |
April | 7% | 4% | -4% | -3% |
May | 5% | 6% | -4% | 8% |
June | 6% | 7% | -2% | 5% |
July | 9% | -1% | -6% | -9% |
August | 4% | -2% | -6% | -7% |
September | 9% | -2% | -4% | 10% |
October | 0% | 10% | 0% | -7% |
November | 5% | -5% | -5% | 6% |
December | 8% | -10% | 3% | 2% |
How to Create Win Loss Chart in Excel
To enter a Win/Loss Sparkline in Excel you firstly need to follow these steps:
Step 1: Select your data (Select First Row);
Step 2: Insert > Sparklines > Win/Loss
Step 3: Select the Location range, that you want to insert the Win/Loss Sparklines (this is usually the next column after your data ends) and press OK
Step 4:. You will get Sparklines on the first row. Now drag the first row till the end so that every row will have series of Sparklines. So the resultant chart will be like
Step 5: If you want to change the Style or color of the Sparklines, then select all the Spraklines and click design tab and from the drop down select the design that suits you to represent the win loss chart in an appealing format as shown below.
So the Final Win Loss Chart in Excel will be like