1. Computing & Technology

Discuss in my forum

Create a PowerPoint 2007 Column Chart

By , About.com Guide

Edit Column Chart Data for PowerPoint Slide
Replace generic PowerPoint chart data with your own data in the Excel spreadsheet

Replace generic PowerPoint chart data with your own data in the Excel spreadsheet

© Wendy Russell

Edit the Column Chart Data

Add Your Data

  1. Click on the Excel 2007 window to make it the active window. Notice the blue rectangle that surrounds the chart data. These are the cells that are used to create the column chart.
  2. Edit the headings of the columns in the generic data to reflect your own information. In the example shown, these column headings have been changed to Hobo, Satchel, Evening Bag.
  3. Edit the row headings in the generic data to reflect your own information. In the example shown, these row headings have been changed to July, August, September.

Add More Columns or Rows
  • Method 1
    1. Drag the bottom right corner handle on the blue rectangle to enlarge the selection of data to include as many columns or rows as you need. Notice that the blue rectangle will expand to incorporate these new columns/rows.
    2. Type a new heading in the new available column(s) or row(s).
  • Method 2
    1. Type a new heading in the next available column or row.
    2. Press the Enter key to enter the data. Notice that the blue rectangle will expand to incorporate this new column/row.
    3. Repeat this process for each new row or column.

Delete Columns or Rows from the Generic Data

  • Drag the bottom right corner handle on the blue rectangle to reduce the selection of data -- for columns or rows or both.
  • Notice that the blue rectangle will become smaller to incorporate these changes.

©2012 About.com. All rights reserved.

A part of The New York Times Company.