Edit the Pie Chart Data
Pie charts can only display one type of data. If you need to show more than one type of data information you will need to choose a different type of chart, such as a column chart.
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 pie chart.
- Edit the heading of the column in the generic data to reflect your own information. In the example shown, this column heading has been changed to Monthly Household Expenses.
- Edit the row headings in the generic data to reflect your own information. In the example shown, these row headings have been changed to Mortgage, Hydro, Heat, Cable, Internet, Food.
- Replace the generic numeric data with your own data.
Add More Data Rows
If the generic chart data does not how enough rows, you can easily add additional rows to accommodate your own data.
- Method 1
- Type a new heading in the next available row.
- Press the Enter key to enter the data. Notice that the blue rectangle will expand to incorporate this new row.
- Add the appropriate numerical data for this new entry.
- Repeat this process for each new row you need.
- Method 2
- Drag the bottom right corner handle on the blue rectangle to enlarge the selection of data to include as many extra rows as you need. Notice that the blue rectangle will expand to incorporate these new rows.
- Type headings in the new available rows.
- Add the appropriate numerical data for the new row heading(s).
Delete Extra Data Rows from Generic Data
- Drag the bottom right corner handle on the blue rectangle to reduce the selection of data cells.
- Notice that the blue rectangle will become smaller to incorporate these changes.
- Delete any information in the cells outside the blue rectangle that is not wanted for this pie chart.
