1. Computing

Excel Column Chart Step by Step Tutorial

By , About.com Guide

3 of 9

Select the Column Chart Data
Excel 2007 Column Chart

Excel 2007 Column Chart

© Ted French

Two Options for Selecting the Chart Data

Using the mouse

  1. Drag select with the mouse button to highlight the cells containing the data to be included in the column chart.

Using the keyboard

  1. Click on the top left of the column charts's data.
  2. Hold down the SHIFT key on the keyboard.
  3. Use the arrow keys on the keyboard to select the data to be included in the column chart.

Note: Be sure to select any column and row titles that you want included in the chart.

For this tutorial

  1. Highlight the range of cells from A2 to D5, which includes the column titles and the row headings

©2013 About.com. All rights reserved.