

What are Sparklines in Excel 2010?


Excel 2007 
Excel 2003 
Macros
Excel 2007 
Macros
Excel 2003 
Excel 2010 
About
Us 
Free
Ebook 
Offline
Training 
Blog 
Books 

In Microsoft Excel
2010 a new
feature called sparklines
has
been introduced.
What are sparklines? A sparkline is a tiny chart in the Excel spreadsheet cell next to the data. The chart provides a quick visual representation of the data showing trends at a glance such as the effect of your advertising, economic conditions or festivals like Diwali or Christmas. You can quickly observe whether your sales are growing, stagnant or falling. Sparklines can be represented as a line, columns or win/loss diagrams. Just like other calculations you can also perform an autofill for the sparkline. In fact, the sparklines get printed like any other data. How to create a sparkline:
Once the sparkline is created you can customize it to highlight negative, high and low values using different colours, for example. You can apply a different design to the sparklines or show the empty cells as gaps or zeros or show data in hidden rows or columns. You can also reflect the different time periods between two data points by proportionally increasing the space between them. For example, most of of your data may be monthly but one or two data points may be quarterly. Let's see the details in the following Excel 2010 training video. 



Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 
About Us  Free Ebook  Offline Training  Blog  Books 