1. Computing

Excel 2010 Sparklines Tutorial

By , About.com Guide

2 of 4

Entering the Sparklines Tutorial Data
Excel 2010 Sparklines Tutorial

Excel 2010 Sparklines Tutorial

© Ted French

Entering the Sparklines Tutorial Data

Note: For help with these instructions, see the image example above.

No matter which of the three sparklines you are creating, the first step is always to enter the data into the worksheet.

When entering the data, keep these rules in mind:

  1. Don't leave blank rows or columns when entering your data. Even though sparklines can adjust to blank cells, it is best to avoid them whenever possible.

  2. Enter your data in columns.
    • When laying out your spreadsheet, list the names describing the data in one column and, to the right of that, the data itself.

    • If there is more than one data series, list them one after the other in columns with the title for each data series at the top.

For this tutorial

  1. Enter the data as seen in the image above into cells A1 to F2 in a worksheet.

Return to Index Page.

©2013 About.com. All rights reserved.