Find the spreadsheet you want to edit on your computer, and double-click on its icon to open the worksheet.

Find the chart you want to modify in your spreadsheet, and click on it to select the chart.

This will open a new dialogue box where you can edit your legend and data values.

Find the entry you want to edit here, and click on it to select it.

This will allow you to edit the selected entrys name and data values.

In this case, you can skip this step, and look for the Name or Series Name field in the same dialogue box.

Double-click the text field, delete the current name, and enter the name you want to assign to this entry in your charts legend.

This will copy and assign the selected cells contents as the entry name.

You can delete the selected entrys current value here, and type in a new value to change your chart.

Open a spreadsheet, and click the chart you want to edit.

Click the Design or Chart Design tab.

Select a legend entry, and click Edit.

Enter a new name into the Series Name or Name box.

Enter a new value into the Y values box.

By continuing to use our site, you agree to our cookie policy.

Change Legend In Excel Free By Whitelisting

Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

How To Change Legend In Excel For Mac