You can edit the data of an existing sparkline by using the Edit Data option.
In this contextual tab, you’ll find all the customization option for the selected sparkline type.Įditing the DataSet of Existing Sparklines When you select a cell that has a Sparkline, you’ll notice that a contextual tab – Sparkline Tools Design – becomes available. While the above steps insert a basic sparkline in the cell, you can do some customization to make it better. To insert a ‘Column’ or ‘Win-loss’ sparkline, you need to follow the same above steps, and select Columns or Win-loss instead of the Line (in step 3). This will insert a line sparkline in cell G2. In the ‘Create Sparklines’ dialog box, select the data range (A2:F2 in this example).In the Sparklines group click on the Line option.Select the cell in which you want the sparkline.Here are the steps to insert a line sparkline in Excel: Let’s say that you want to insert a line sparkline (as shown below). Now let’s cover each of these types of sparklines and all the customizations you can do with it. In this tutorial, everything covered for column sparklines can also be applied to the win-loss sparklines. For example, if you’re plotting whether it rained in the past 7 days or not, you can plot a win-loss with 1 for days when it rained and -1 for days when it didn’t. It is better used in situations where the outcome is binary, such as Yes/No, True/False, Head/Tail, 1/-1, etc. Note: A Win-loss sparkline is just like a column sparkline, but it doesn’t show the magnitude of the value.
We will see how to do this for each sparkline type later in this tutorial.
Sparklines are tiny charts that reside in a cell in Excel. Editing the DataSet of Existing Sparklines.