99.1% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
What Is A Sparkline And How Do They Work?
Mon 7th June 2010
While larger charts are in their own area on a page, a trend line can be shown next to the appropriate data. As an example, a user is looking at three columns showing monthly sales data over three months with a row for each sales office. In an additional column, a tiny trend line chart shows a visual interpretation of the sales statistics per row or office. The patterns and trends of the data can be easily shown without leaving the data.
One major advantage of the tiny charts embedded in a cell is that they work in a similar way to pivot tables in that changes in the data are reflected in the chart automatically. No refresh is necessary since the chart changes as soon as the data is amended. The Sparkline charts are very user friendly since they hold some of the behaviour of an ordinary cell. When a user enters formulas in a cell, the formula cell can be dragged to other cells to automatically update it for other rows. In the same way a Sparkline can be dragged to other rows so that the user only needs to create one initial Sparkline before dragging it to other rows. The data in the Sparkline will automatically be updated with data from the appropriate row.
There are three kinds of Sparkline charts which are 'Line', 'Column' or 'Win/Loss' and these are intuitively set out on the insert tab within their own group. Once the user selects the chart type, a simple box appears allowing the data selection. Once the OK button is clicked, the chart features automatically appear in a banner at the top of the screen allowing a user to customise the chart by picking and choosing a series of simple options.
When you click out of the Sparkline cell these options will disappear and it is not immediately apparent how to make further changes. When you click back into the Sparkline cell an additional 'Design' tab appears at the top of the screen. The same options then allow the user to continue with customisation of the charts. These options are placed into groups to help the user navigate the options banner more easily.
A useful colour palette is enabled which allows the user to fully control the colours within the chart. This could be particularly useful when presenting the data since the RGB colour selector allows the user to enter specific company branded colours for use within the Sparkline charts. The colour selection is advanced since there is a 'Marker Colour' section allowing the user to define the colours for a range of different markers. Negative marker points can be red for example, while positive can be green. High, Low, First and Last Points can all be controlled fully and separately and all have the full palette and RGB and HSL colour controls.
If you have used fill or drag to create the charts in a column, it may be that the top row chart should stand out because the data is for the total sales figures for all offices. Rather than deleting the existing chart and building it again separately, there is an option to 'Ungroup' a particular chart. This means that any format controls completed on that particular chart will not automatically reflect in all the other charts.
The Sparkline feature will be a useful addition to the presentation abilities of Excel. Charts full of data no longer have to be in a separate place or squashed into an area far too small for them. Particularly since they automatically appear without axis, they are a reasonable way to quickly and simply show the trend and pattern of the data. Presenting data in a way that gets the message across in an interesting way is always a challenge. Often a spreadsheet designer will find that a manager will not be interested in seeing pages of statistics, regardless of how long they took to collate. A simple visual representation showing the message and comparisons behind the data is invaluable.
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
Excel Pivot Tables
I really enjoyed the course. It was nice to have the pivot table course but I also appreciated the other helpful Excel tips.
Projects And Operations Administrator
Course was perfectly paced and presented. Really helpful and patient instructor. I'd used excel previously but this has improved my overall confidence. I now won't need to ask people how to do things as much!
Royal Borough Of Kensington & Chelsea
Admin Support Officer
Training is genetic. Tips are fantastic and practice makes perfect. Provided all the hat I need to b able to function as a note taker but with practice.