Edit the Column Chart Data
Add Your Data
- 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.
- 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.
- 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.
- Method 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.
- Type a new heading in the new available column(s) or row(s).
- Method 2
- Type a new heading in the next available column or row.
- Press the Enter key to enter the data. Notice that the blue rectangle will expand to incorporate this new column/row.
- 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.




