How to Rename a Legend in Microsoft Excel 2007

Edit Legend Directly
1. Open a Microsoft Excel 2007 document. To rename a legend in Excel, you need an existing document with data and a chart.
2. Select the chart whose legend you want to edit. The 'Chart Tools' will appear in the Ribbon, including the 'Design, Layout and Format' tabs.
3. Click the 'Design' tab. Click 'Select Data' in the 'Data' group. The 'Select Data Source' dialog box appears.
4. Click the legend entry you want to edit listed in the 'Legend Entries (Series)' box. Click 'Edit.' The 'Edit Series' dialog box appears.
5. Select a new worksheet cell you want to use as the legend text by clicking the 'Collapse Dialog Box' button next to 'Series Name' and selecting the cell from your worksheet. Click the button again to go back to the box. Click 'OK.'
6. Type a new name for the legend entry (instead of selecting a worksheet cell). Enter the name in the 'Series Name' field. If you type a new name, the legend won't be linked to a cell entry. Click 'OK.' You'll see the change immediately in the chart legend.
7. Click the 'Microsoft Office Button' and click 'Save as' to save the changes.
Edit Legend Via Worksheet
8. Open the Excel worksheet on which you want to rename a chart legend. Select the worksheet cell that has the same entry as the legend.
9. Type a new name and press 'Enter.' The new name will immediately appear in the chart legend.
10. Click the 'Microsoft Office Button,' and select 'Save as' to save the changes.