Win Loss Chart in Excel

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

 Week1Week2Week3Week4
January7%-3%-1%-8%
February-2%9%-5%-9%
March2%5%10%3%
April7%4%-4%-3%
May5%6%-4%8%
June6%7%-2%5%
July9%-1%-6%-9%
August4%-2%-6%-7%
September9%-2%-4%10%
October0%10%0%-7%
November5%-5%-5%6%
December8%-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

win loss chart in excel 1

 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

win loss chart in excel 2

 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

win loss chart in excel 3

 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.

win loss chart in excel 4

So the Final Win Loss Chart in Excel will be like

win loss chart in excel 5

previous small win loss chart in excel                                                                                                                next small win loss chart in excel