Edit the Line Chart Data
Add Your Data
Line charts can display multiple types of data.
- Click on the Excel 2010/2007 window to make it the active window. Notice the colored rectangle that surrounds the chart data. These are the cells that are used to create the line chart.
- Edit the first column heading (cell B1) and edit the text to reflect your own data. In the example shown, this column heading has been changed to Sedan. Repeat to edit the other column headings.
- Edit the row headings in the generic data to reflect your own information. In the example shown, these row headings have been changed to 2008, 2009, 2010 to reflect car sales for those models.
- Replace the generic data with your own numerical data.
Add More Columns or Rows in the Spreadsheet
If the generic chart data does not have enough columns and/or rows, you can easily add additional ones to accommodate your own data.
- Method 1
- Type a new heading in the next available column/row.
- Press the Enter key to enter the data. Notice that the colored rectangle will expand to incorporate this new column/row.
- Add the appropriate data for this new entry.
- Repeat this process for each new column/row you need.
- Method 2
- Drag the bottom right corner handle on the colored rectangle to enlarge the selection of data to include as many extra columns/rows as you need. Notice that the colored rectangle will expand to incorporate these new columns/rows.
- Type headings in the new available columns/rows.
- Add the appropriate data for the new column/row heading(s).
Delete Columns/Rows from the Generic Data
- Drag the bottom right corner handle on the colored rectangle to reduce the selection of data cells.
- Notice that the colored rectangle will become smaller to incorporate these changes.
- Delete any information in the cells outside the colored rectangle that is not wanted for this line chart.
