Sparklines – Excel Feature not so common to many

Excel 2013 has some interesting amazing features which makes it a lot easier for you to complete your activity which otherwise would have taken most of your time. In Excel 2013, you can use a new Quick Analysis tool known as Sparklines. I suppose many of you would be still thinking what this Sparkline is. Why is it used? How do you add sparklines to the data? You will find all the answers below.

A Sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values.

Sparklines is a great tool for creating visual representation of data with one click. In case you want to identify the pattern of the data presented in rows and columns using Sparklines can be highly useful. A Sparkline can display a trend based on adjacent data in a clear and compact graphical representation. It is advisable for a Sparkline cell to be directly next to its underlying data.

 To create a Sparkline

 Select an empty cell or group of empty cells in which you want to insert one or more sparklines.

Got to the Insert Tab, select any of the type of Sparklines that you want to create from the Sparklines group. Sparklines are of 3 types namely LineColumn, or Win/Loss. You may choose any one of these.

 

When you select the Sparkline, Create Sparklines dialogue box will appear. To select the data range you will have to click on  box. When you click the box another dialogue box called Create Sparklines will appear using which you can select the data range to base the sparklines.You can click  to to temporarily collapse the dialog box, select the range of cells that you want on the worksheet, and then click  the same box to restore the dialog box to its normal size.

 

When one or more sparklines are inserted, the Sparkline Tools appears, displaying the Design tab. On the Design tab, you can choose one or more of several commands from among the following groups: Sparkline, Type, Show/Hide, Style, and Group. Use these commands to create a new Sparkline, change its type, format it, show or hide data points on a line Sparkline, or format the vertical axis in a Sparkline group.

Using Sparklines will enable you to see the relationship between a Sparkline and its underlying data, and when your data changes you can see the change in the Sparkline immediately. In addition to creating a single Sparkline for a row or column of data, you can create several spark lines at the same time by selecting multiple cells that correspond to underlying data, as shown in the following picture.You can also create sparklines for rows of data that you add later by using the fill handle on an adjacent cell that contains a Sparkline.

 

 

About the author

FAME is a leading Accountancy training provider. FAME brings together under one roof a wide range of accounting courses blended with real world experience and practical application. FAME aims to bridge the gap between theoretical knowledge and practical challenges that accountants face in their day to day working. We provide practical workplace skills for finance staff meeting the needs of employers, bankers, government and learners, both now and in the future. Our students are integral to the success of an organisation and at the heart of ensuring the smooth running of an accounting department.