On the Insert tab, in the Sparklines group, choose the desired type: Line, Column or Win/Loss.Select a blank cell where you want to add a sparkline, typically at the end of a row of data.To create a sparkline in Excel, perform these steps: Sparklines were introduced in Excel 2010 and are available in all later versions of Excel 2013, Excel 2016, Excel 2019, and Excel for Office 365. You insert sparklines next to the rows or columns of data and get a clear graphical presentation of a trend in each individual row or column. Typical uses include visualizing fluctuations in temperature, stock prices, periodic sales figures, and any other variations over time. Sparklines can be used with any numerical data in a tabular format. The idea is to place a visual near the original data without taking too much space, therefore sparklines are sometimes called 'in-line charts'. How to add sparklines to multiple cellsĪ sparkline is a tiny graph that resides in a single cell.These micro-charts are specially designed to show data trends inside a single cell. Looking for a way to visualize a large volume of data in a little space? Sparklines are a quick and elegant solution. In this tutorial, you will find everything you need to know about sparkline charts: how to add sparklines in Excel, modify them as desired, and delete when no longer needed.

How to add trend lines in excel 2016