Pages

Saturday, October 23, 2010

How to create Sparkline GraphMicrosoft Excel 2010

One new feature in Microsoft Office Excel 2010 is Sparklines. 
 
Sparklines is a graph display of the collection of data in Microsoft Office Excel, but displayed only in one cell. 
 
There are 3 types Sparklines: Line, Column and Win / Loss. 
 
To make it, you are required to have a set of data, just as if you want to create an other graph. Click on the Insert ribbon menu, and select the desired type sparkline. And as usual, you are prompted to set the data that you show with this sparkline graph, and finally determine the cell where you want to display these sparkline.
 

Especially for type Win / Loss, sparkline this type is used if you have a set of data in which there is a negative number. 
 
And as usual, you sparkline graph can be modified in appearance, ranging from about the color until the value to be displayed.
 
 

1 comment:

  1. I like using ms excel, because of it gives me money and related to my job. But one day I had very complicated trouble with ms excel. I was terribly upset. And only one thing forced me to change my mind. It was one tool, which relieved me for some seconds and would be helpful anywhere as well - impossible to read Excel file.

    ReplyDelete