Excel Tips- Sparklines

Using Sparklines to show data trends in Excel

Do you want to show your data like this rather than just numbers and percentages. To do this we use 

Sparklines.

SPARKLINES(Showing drop and increase in Utillzations).

What is a sparkline?

A Sparkline is a small chart that is aligned with rows of some tabular data and usually shows trend information.

Here is an example of sparklines in creating utilization of the employees

Creating Sparkline

Creating sparklines in excel 2010 is very easy. You follow 3 very simple steps to get beautiful sparklines in an instant.

1. Select the data from which you want to make a sparkline.
2. Go to Insert > Sparkline and select the type of sparkline (you have 3 options – line, column and win-loss chart) (line and column are shown here)
   
3. Specify a target cell where you want the sparkline to be placed
4. Optional: Format the sparkline if you want.

Some tips and tricks

1. You can auto-fill the sparklines.
2. You can adjust the size of sparkline by adjusting the size of the cell
3. You can use it along with conditional formatting to make it more visualizing appealing.

This is one of the ways you can make your spreadsheets look for visually appealing in excel. Hope this was helpful.