1. Computing & Technology

Discuss in my forum

Excel Sparklines Overview

By , About.com Guide

4 of 4

Win / Loss Sparklines
Excel 2010 Sparklines Tutorial

Excel 2010 Sparklines Tutorial

© Ted French

Win / Loss Sparklines

Win / loss sparklines show you whether your data is positive (a win) or negative (a loss).

The sparkline displays these differences by placing positive data above the sparkline's X axis (zero line) and negative data below the X axis. The axis line is not shown, but it is situated in the middle of the cell.

If you have a zero value in your data it is treated like a blank cell and no bar is displayed for that cell. A gap is left in the sparkline.

In the example above, the win / loss sparkline reflects the positive growth for the stock in the years 2007, 2008, and 2010 with green bars above the X axis. The loss in stock value in 2009 is shown by the red bar located below the X axis.

©2012 About.com. All rights reserved.

A part of The New York Times Company.