EXCELlent Ones Consulting Skip to Content Skip to Search

Print  |   | Download PDF

Sparklines

Sparklines is a tool added in Excel 2010. Essentially Sparklines are miniature graphs the size of a cell. Sparklines quickly communicate data trends without taking up precious spreadsheet real estate.

1. Above is a table containing sales data by quarter and by region.

2. Click on the Insert tab

3. In the Sparklines section click on the “Line” option

4. In the dialog box enter that data range in the first input box

5. In the second input box enter the destinations of the Sparklines

6. Voila, miniature charts showing the data trend from quarter to quarter by region has been created.


Footer

Email: info@excellentones.com | P.O. Box 160493 | Brooklyn, NY 11216 | Phone: (347) 763-1035 | Fax: (718) 228-7859

All rights reserved. Copyright 2014 Excellent Ones Consulting LLC.