Skip to main content

How to Display Sparklines in Excel 2010, 2007 and 2003

Microsoft Excel 2010 includes a very useful feature called Sparklines. These are little chart displayed in a cell that helps you track and visualize data trends. A Sparkline fits inside a single cell, allowing you to view data and charts on the same table.

Let us add Sparklines to a spreadsheet and see how it works. The Sparklines group is available under the “Insert” tab in the ribbon.

sparklines

Select the cells where you wish to display your Sparklines, and click on the type of Sparklines you wish to display – Line, Column or Win/Loss. In this example, we’ll select Line.

sparklines2

A Create Sparklines dialog box will pop open and you will be prompted to enter a Data Range. With your mouse highlight the cells you wish to use as your data range.

sparklines3

Immediately, Sparklines will appear in the cells.

sparklines4

A new Design tab will appear in the ribbon from where you can customize the Sparklines. You can change color of the Sparklines, add markers, show high points and low points, toggle axis and so on. You can also skip the customization and instead select from one of the several predefined styles available.

sparklines5

The Column Sparklines display data trends in columns, while the Win/Loss Sparklines shows positive or negative representation of your data set.

sparklines6

You can switch between one Sparklines type to another easily.

That was for Excel 2010. Those who are using earlier edition of Microsoft Office, you can enable this feature by way of a third-party plugins. Currently, there are two available:

TinyGraphs is an open source add-in for Excel that creates sparklines, mini column graphs, and area graphs from a row of data. TinyGraphs offers an additional graph type that is not available on Excel 2010 Sparklines, and that is area graphs. Unfortunately, the TinyGraphs add-in is not compatible with Excel 2010. It supports Excel 2000, 2003 and 2007 only.

tinygraphs

The other one is Sparklines For Excel. This supports Excel 2003, 2007 and 2010 as well, and also available for 64-bit editions of Microsoft Office.

sparklines7

Sparklines For Excel is a good plugin but awfully difficult to use. A comparison between Sparklines For Excel and Excel 2010 Sparklines shows both tools evenly balanced, but the plugin version is not very user-friendly.

If you frequently use graphs in Excel, try switching to Sparklines instead.

Labels:

Comments

Post a Comment

Popular posts from this blog

How to Record CPU and Memory Usage Over Time in Windows?

Whenever the computer is lagging or some application is taking too long to respond, we usually fire up task manager and look under the Performance tab or under Processes to check on processor utilization or the amount of free memory available. The task manager is ideal for real-time analysis of CPU and memory utilization. It even displays a short history of CPU utilization in the form of a graph. You get a small time-window, about 30 seconds or so, depending on how large the viewing area is.
17 comments
Read more

How to Schedule Changes to Your Facebook Page Cover Photo

Facebook’s current layout, the so called Timeline, features a prominent, large cover photo that some people are using in a lot of different creative ways. Timeline is also available for Facebook Pages that people can use to promote their website or business or event. Although you can change the cover photo as often as you like, it’s meant to be static – something which you design and leave it for at least a few weeks or months like a redesigned website. However, there are times when you may want to change the cover photo frequently and periodically to match event dates or some special promotion that you are running or plan to run. So, here is how you can do that.
1 comment
Read more

Diagram 101: Different Types of Diagrams and When To Use Them

Diagrams are a great way to visualize information and convey meaning. The problem is that there’s too many different types of diagrams, so it can be hard to know which ones you should use in any given situation. To help you out, we’ve created this diagram that lays out the 7 most common types of diagrams and when they’re best used:
Post a Comment
Read more