by Allen Wyatt
(last updated October 13, 2018)
Excel 2010 introduced a new feature referred to as sparklines. They are nothing more than miniature charts that can appear inside a single cell. The graphs aren't as varied and full-featured as regular Excel charts, but they are pretty cool, nonetheless. They are especially good for showing, at a glance, the general trend of the numbers in a range of cells.
To create a sparkline, follow these steps:
Figure 1. The Create Sparkline dialog box.
You should see your sparkline appear immediately in the cell you specified in step 1.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12588) applies to Microsoft Excel 2010, 2013, 2016, 2019, and Excel in Office 365.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
A common place to use Excel charts is in your PowerPoint presentations. How you paste those charts into the presentation ...Discover More
Do you use Excel's charting capabilities to display three-dimensional views of your data? The program provides a way that ...Discover More
When creating a chart, your axis labels may be wider than desired. One way to deal with them is to change the angle at ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.