Utilizing Sparklines in Ms Excel 2010

Overview

As a Microsoft coach I can remember reviewing Sparklines back in 2010 when they were new and predicting that they would become a well-known system in Excel. In hindsight it appears I could perhaps have been slightly hasty in my view. I’ve yet to come across anybody who perceives them to be as beneficial as I proposed, however, almost certainly that’s because most people still haven’t encountered them yet?

Primarily a Sparkline works as a mini-graph which occupies only one cell within the spread sheet. They’re helpful. for distinguishing patterns inside data, in exactly the same way the recognized graph and chart option is. However, the big benefits of Sparklines are their tiny size along with ease of use.

Creating a Sparkline

This is certainly a straight forward process and one which you'll most probably become pretty acquainted with:

1. First select the ‘Insert’ tab on the ribbon then click on the ‘Line’ tool within the Sparklines group.

2. With the cursor flashing inside the ‘Data Range’ field, click and drag over the array of cells that your Sparkline is actually to represent.

3. Next tab to the ‘Location Range’ field and click in the individual cell where the Sparkline is going to be built.

4. Finally click on ‘OK’ and the Sparkline will be built as a form of line chart.

It is probably worth noting that Sparklines can be put anywhere in the worksheet, and do not have to be within the same row or perhaps in the same column. In doing this, Sparklines can easily be arranged together so that you can illustrate changes inside a wide range of data at a glance.

Replicating Sparklines

Sparklines function much like any other formula because they they may be copied down a column as well as across a row to graph or chart a large number of data ranges. Just create your first Sparkline, then click on the AutoFill handle (the little black square situated within the bottom right hand corner of each and every cell) and drag down a column or across a row. Additional Sparklines will instantly be formed that will represent data ranges inside related rows or columns.

Formatting Sparklines

The default Sparkline graph format is frequently possibly not as useful as it might be. Thanks to their very small size, Sparklines can benefit from a graphic ‘boost’ by adding and refining the format choices available.

Adding Markers

Some additional markers are often added that will identify data points within the Sparkline. This can be done merely by ticking the related boxes within the ‘Show’ group on the ‘Design’ tab of the ribbon. Checking the ‘Markers’ selection will pick all points within the Sparkline graph. A wide selection of predefined styles is offered within the ‘Styles’ group and may be applied by just clicking the style required. The colour combination scheme can easily be tailored by picking out individual Sparkline and Marker colours from the tools located immediately to the right of the Styles group.

Swapping Sparkline Charts

There are 3 sorts of Sparkline graphs offered: Line, Column and Win / Loss. The type can be switched through highlighting the Sparkline cell and then simply clicking on the appropriate the type tool button.

Customising the Axis

There are a number of alternatives which permit fine-tuning of the Sparkline axis options. In the event that you have got dates within your data range you can opt for the ‘Date Axis Type’ via the ‘Axis’ tool on the ribbon. This is especially valuable when you have varying dates in a range. The vertical axis minimum values can also be modified employing this tool. The default value is ‘Automatic for every Sparkline’, but this may be altered to ‘Same for each Sparkline’. One issue with Sparklines is that due to their compact size, significant variations throughout data ranges from one Sparkline graph to another could result in misleading results. Applying option, the scale may modified to accomodate the entire range of information being charted.

Overview of Sparklines

We can observe then that Sparklines undoubtedly are a surprisingly effective method of showing data in a graphic manner in order that we're able pick up on trends. To help get the absolute best from them, we need to look beyond the default graph view and be experienced with the range of layout possibilities.

For details of microsoft courses go here