by Allen Wyatt
(last updated May 11, 2017)
Excel 2010 introduced a new feature referred to as sparklines. There 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 and 2013.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
If you have a lot of records in a data table, you may want to create individual charts based on the information in those ...Discover More
Excel is an excellent tool for keeping track of data over time. If you have information you are keeping by year, you may ...Discover More
Want a handy way to make the data ranges for your chart more dynamic? Here are some great ideas you can put to work right ...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.