What are Sparklines in Excel 2010?
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