Excel 2007 Column Chart Tutorial

Select the Column Chart Data

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

• Create a Column Chart in Excel 2007
• 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