Excel 2010 comes with a new feature included, which is known as Sparklines. This is a graphical option that will allow you to add little, one-cell charts into the middle of your spreadsheet. As such, you will be able to provide your viewer with a visual representation of the data. This will help this data to look a lot more organized.
An example of when you might want to use Sparklines is whenever you wish to display data in a line or a column in order to show win/loss or to highlight a specific trend that has occurred. You may also want to use it in order to track and highlight any important trends that are occurring within your Excel spreadsheet.
Here is how Sparklines can benefit you whenever you are creating an Excel spreadsheet. If you are reading a chart about how many sales occurred each day over the course of a week, you could see a little image representing each of the rows in the chart. This can be included within the report in such a way that you would never even need to flip a page in order to see the image. In doing so, Excel makes it really easy for you to be able to review and understand any data trends that are occurring within the report that you are viewing.
In order to use Sparkline you will want to go to your Insert tab. There you will find “Sparkline” and a range of data that you will be able to choose from. Here is where you will be able to customize your Sparklines. If you select the Sparkline, then choose the Design tab you will be able to give them the best effects possible, which is something that you were never able to do before with any Excel program prior to the 2010 release of this version of the software.