Excel Column Chart Step by Step Tutorial

By Ted French, About.com Guide

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

Previous

• Create a Column Chart in Excel
• Entering the Chart Data
• Select the Column Chart Data
• Selecting a Column Chart Type
• The Basic Column Chart
• Formatting the Column Chart - 1
• Formatting the Column Chart - 2
• Formatting the Column Chart - 3
• Column Chart Tutorial Data

Next