Microsoft Excel 2010 includes a very useful feature that many people don’t know about. In Excel 2010, you can create sparklines. Sparkline is a type of information graph of a single row which can fit into a single cell.
The sparklines feature can be accessed from Excel 2010 ribbon in Insert tab. There is a separate group for sparklines on the ribbon.
To insert a sparkline, select the cell in which you want to show the sparkline, go to Insert –> Sparklines group and select the type of graph you want to show. There are three types of graphs available:
- Line
- Column
- Win/Loss
You can select any type to insert the sparkline. A dialogbox will appear asking you for the range for which you want the sparkline. You will need to select the row for which you want to make the mini-graph.
That’s it. Pressing OK will display the one cell mini-graph which can be very useful to analyze the data quickly.
You can also customize the sparklines that you have created. Just click on the cell in which the sparkline has been created. A new Design tab will appear on the ribbon. Click Design and customize the look and feel of the sparkline.
Enjoyed the article? Sign-up for our free newsletter or RSS feed or leave us a comment.
- How To Work Simultaneously On One Excel Workbook By Multiple Users
- How To Convert An Office 2003 File To Office 2010 Format
- Download Office 2010 Cumulative Update for October 2010
- 17 Beautiful Chart Templates For Microsoft Excel And Powerpoint
- The File Size Of Excel Workbook May Unexpectedly Increase Exponentially