1. Computing

Excel Column Chart Step by Step Tutorial

By , About.com Guide

2 of 9

Entering the Chart Data
Excel 2007 / 2010 Column Chart

Excel 2007 / 2010 Column Chart

© Ted French

Enter the Chart Data

The first step in creating a column chart is 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.

  2. Enter your data in columns.

    • Note: 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.

To follow this tutorial, enter the data located in step 9.

©2013 About.com. All rights reserved.