How to Insert Win/Loss Sparklines in Excel

Very similar to column Sparklines, Win/Loss sparkline is one of the mini charts that are placed in a single cell, representing the data you selected. If you have made one of them and want to switch to another, please see How to Change Sparklines Types. Otherwise, please follow the steps below to add win/loss sparklines for data rows:

Step 1: Click the cells that you want to insert the win/loss sparklines, mostly the cells right after the data range;

Step 2: Click the "Insert" tab from the ribbon;

Step 3: Click the "win/loss" command from "Sparklines" section;

Step 4: Select the data range that you want to insert the win/loss sparklines (e.g., A1:D3);

Step 5: Click "OK" at the bottom and you will see the charts in the cells;

Step 6: If you want to change the color, click the "Sparkline" tab from the ribbon;

Step 7: Click "Sparkline color" and select one color from the theme colors;

Step 8: For example, select the "Light blue" color.

Leave a Reply