Microsoft Excel 2010

Show Trends Inside a Cell via Sparklines

SUMMARY: Display miniature graphs, sparklines, showing trends in a series of data in an Excel 2010 worksheet.

While it is relatively easy to place multiple graphs inside a Microsoft Excel 2010 worksheet, adding too many may make your document seem unwieldy. However, multiple graphs may prove useful, especially when determining trends. For example, a worksheet containing rows of prices of different stocks across several quarters might benefit from graphs showing the trends of each stock's price. The same could be said for a group of students' grades (see the below screenshot), sales figures from your sales team, etc.

With the use of "Sparklines" you can add smaller miniature graphs for each row of data illustrating trends for each row:

An Excel 2010 worksheet of student grades that may benefit from Sparklines

1. Highlight the cells containing the data for which you wish to generate trend graphs (Sparklines):

2. Select the "Insert" tab in the Ribbon.

3. In the "Sparklines" group, click either the "Line" or "Columns" button (the Win/Loss Sparkline shows trends in a slightly different way and is outside the scope of this tip).

4. The "Create Sparkline" dialog box appears. From here, enter the range of data that will be used to create the Sparkline as well as the cells where you want the Sparklines placed. You can click the buttons next to the input boxes to visually select the ranges, if desired.

Note that while the below screenshot shows Sparklines placed in their own blank cells, this does not have to be the case. If desired, you can place Sparklines directly behind live data inside cells!

Choosing the Sparkline data range and where to place the graphs in Excel 2010

5. Click "OK" to generate your Sparklines - see the below screenshot for an example.

Sparklines generated from the example worksheet in Excel 2010

Names used for this sample worksheet are fictitious. Any resemblance to real persons, living or dead, is purely coincidental.

Return to the Microsoft Excel 2010 page.

Thanks For Sharing!



Newest Tips

Cell Phone
[MODIFIED] Six Battery Conservation Tips
Google Search Engine
What is My IP Address?
Mozilla Firefox - Misc
Missing the Title Bar? Menu Bar?
Windows 8
Bring Back the Mouse Pointer Drop Shadow

Follow/Contact Us!


About MalekTips and the Author

The MalekTips website was created in 1998 by of Envision Programming. The page's goal is to freely disperse computer-related tips, hints, and informative articles. Tips are organized to be easy to find, and are presented clearly, in easy-to-understand language.