how to add sparklines in excel 2010 - creativeworld9

728x90 AdSpace

Trending
Monday, March 12, 2012

how to add sparklines in excel 2010

In this post I will explain you how to use Sparkline in ms excel 2010.One of the cool new features added in Excel 2010 is Sparklines. In this we use  the names of graphs and other such information, but you may not have heard of Sparklines

                                       A Sparkline is a small, high density graph that is meant to present a condensed form of information. Unlike a full graph, that usually has a visible X and Y axis , Sparklines are alone. They don’t provide as much detail as a normal graph, but because there’s no X and Y axis .you can fit Sparklines into small spaces – like a cell on a Microsoft Excel spreadsheet - easily.

                                  There are 3 different types of Sparklines; line, column and win/loss. The first two are likely to be familiar to anyone who has used charts even a few times before. The line chart makes a graph of each data point and then draws lines between them, of course, and the column chart make each data point an appropriately sized column. The win/loss option is a bit different, however; it presents information as a binary “up” or “down” box.

                                                     Sparklines are simple to insert. You only need to click the appropriate Sparklines button in the insert tab and then select the data you want to graph. Everything e is done for you automatically. You can click on the Sparkline and select the Sparkline Tools tab to make some adjustments. For example, line graphs are smooth by default, but you can click the Markers checkbox to add a square box to represent each data point. You can also edit the colours of the graph. One popular example is the use of a green colour to highlight the most positive data on a graph and a red colour to indicate the most negative.
how to add sparklines in excel 2010 Reviewed by creativeworld9 on 1:32 PM Rating: 5 In this post I will explain you how to use Sparkline in ms excel 2010.One of the cool new features a...

No comments: