How to use Sparklines in Excel 2010

Network administration - Microsoft Excel 2010 allows users to analyze information in many ways than previous Excel versions. The main difference is Sparklines. So what are Sparklines and what does it do for you in analyzing information?

First to go into detail, we need to know that Sparklines is a mini-chart that you can put inside cells to be able to see data and charts on the same table.

Below we will show you how to insert Sparkline charts in an Excel spreadsheet page.

Let's start with a very common spreadsheet page - in the example below, we used a sales report template from Excel 2010 but you can also use it with any Excel spreadsheet that has digital data.

How to use Sparklines in Excel 2010 Picture 1

Select the cells you want sparkline to appear. Put it next to the board to make it easier to see.

How to use Sparklines in Excel 2010 Picture 2

Click the Insert menu from the ribbon, then select 'column' under the Sparklines group.

How to use Sparklines in Excel 2010 Picture 3

Selecting and entering the cell range will be the data source for the chart.

How to use Sparklines in Excel 2010 Picture 4

The charts will appear on the side of the board.

How to use Sparklines in Excel 2010 Picture 5

At first glance you can see the trend of sales going up or down. For example, circled cells are in a growing trend.

How to use Sparklines in Excel 2010 Picture 6

Using the right Sparklines, data analysis will be faster and more oriented and you will certainly have a simpler view when observing information and making decisions.