{"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 In Excel 365, there are 3 types of Sparklines: Line, Column<\/strong>, and Win\/Loss<\/strong>.<\/p>\n\n\n\n Similar to the line chart<\/a>. It can display a marker for each data point.<\/p>\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 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 To make it easier to understand how the Sparklines work, let\u2019s create them using the following example.<\/p>\n\n\n\nSparkline types<\/h2>\n\n\n\n
Line Sparkline<\/h3>\n\n\n\n
Column Sparkline<\/h3>\n\n\n\n
Win\/Loss Sparkline<\/h3>\n\n\n\n
Creating a chart<\/h2>\n\n\n\n