{"id":576,"date":"2018-06-28T12:16:54","date_gmt":"2018-06-28T12:16:54","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=576"},"modified":"2024-03-14T13:12:26","modified_gmt":"2024-03-14T13:12:26","slug":"sparklines","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/sparklines\/","title":{"rendered":"Sparklines"},"content":{"rendered":"\n

Sparklines<\/strong> were introduced in Excel 2010. They are tiny graphics that look like miniature charts but occupy only one cell.<\/p>\n\n\n\n

Compared to standard charts, they are much simpler\u2013 they don\u2019t have gridlines, borders, legend, or callouts. These limitations make it more versatile than the standard charts<\/a>. Thanks to their small size, you can easily fit them in the worksheet.<\/p>\n\n\n\n

Using Sparklines<\/strong> is simple and intuitive. Remember, however, that their purpose is not to replace standard charts, but to inform about trends or patterns, giving you a quick preview of the data.<\/p>\n\n\n\n

Sparkline types<\/h2>\n\n\n\n

In Excel 365, there are 3 types of Sparklines: Line, Column<\/strong>, and Win\/Loss<\/strong>.<\/p>\n\n\n\n

Line Sparkline<\/h3>\n\n\n\n

Similar to the line chart<\/a>. It can display a marker for each data point.<\/p>\n\n\n\n

Column Sparkline<\/h3>\n\n\n\n

This mini chart creates a series of vertical bars, one for each value. The larger columns represent higher values. It\u2019s a mini version of a column chart<\/a>.<\/p>\n\n\n\n

Win\/Loss Sparkline<\/h3>\n\n\n\n

In this chart, Excel creates a series of squares and places them in one of the two positions. If the value is positive then the square is placed at the top of the cell (Win), if it’s negative then it is placed at the bottom (Loss).<\/p>\n\n\n\n

Creating a chart<\/h2>\n\n\n\n

To make it easier to understand how the Sparklines work, let\u2019s create them using the following example.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Select cell J3<\/strong>, then go to INSERT >> Sparklines<\/strong> and click the Line Sparkline<\/strong>. The Create Sparklines<\/strong> window will appear.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Select the cells that you want to be included in your chart. For this example, it will be cells from C3<\/strong> to I3. <\/strong>After you select the cells and press the OK<\/strong> button, a new Sparkline<\/strong> will appear in cell J3.<\/strong><\/p>\n\n\n\n

To fill the example with the rest of the Sparklines<\/strong>, use the AutoFill<\/strong> feature. In a similar way, you can insert the other two types of Sparklines.<\/strong><\/p>\n\n\n\n

Here is an example:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Selecting specific points<\/h2>\n\n\n\n

With Sparklines<\/strong>, you can highlight particular points. If you want to use them, click the Sparkline<\/strong> first and go to SPARKLINE TOOLS >> DESIGN >> Show<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You can select one or more checkboxes. After you do it, the points will automatically appear in the sparklines.<\/p>\n\n\n\n

High and Low points<\/h3>\n\n\n\n

Highlight the highest and lowest value in the data series.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

First and the Last point<\/h3>\n\n\n\n

Highlight the first and the last value of the series.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Negative points<\/h3>\n\n\n\n

Highlight all values that are lower than zero.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Markers<\/h3>\n\n\n\n

Highlight every data point. It works only with the Line Sparklines<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Removing Sparklines<\/h2>\n\n\n\n

You cannot delete a Sparkline<\/strong> the same way you delete regular data. To clear the contents of a cell, click it and go to SPARKLINE TOOLS >> DESIGN >> Group >> Clear<\/strong>.<\/p>\n\n\n\n

In the drop-down menu, you have two options. The first one is Clear Selected Sparklines<\/strong>\u00a0and the second one is\u00a0Clear Selected Sparkline Group<\/strong>.<\/p>\n\n\n\n

Excel 365 Update<\/h2>\n\n\n\n