Quick summary
You can change the legend text of a Microsoft Excel chart by accessing Select Data through the Chart menu and editing each series name directly. This method lets you rename any chart legend label without altering your underlying worksheet data.
Steps
- In your Microsoft Excel worksheet, find and select the chart you wish to edit.
- Navigate to the top menu bar and click the 'Chart' option.
- Choose 'Select Data' from the available dropdown options.
- Click the 'Format' tab to proceed further.
- Locate and select the data series represented by the legend you wish to edit.
- Tap the 'Series Name' field and replace the default name with your new legend label; repeat this for each additional series.
- After completing these steps, the legend text of the selected chart will be updated based on your input.
