Change Excel Chart Legend Names on Mac
Question details
The user wants to replace generic chart legend labels with meaningful series names in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A chart displays labels such as Series 1 and Series 2 instead of the source column headings.
- Observed behavior
- The Select Data dialog may not allow the series names to be edited.
Locate the worksheet cells that contain the chart's source data and column headings. Check whether the chart uses those headings as series names before moving the data to a new workbook.
Recreate the chart in a new Excel workbook
Use a new workbook to test whether the original file is preventing series names from being edited.
Select the chart's source data and column headings in the original worksheet, then choose Edit > Copy.
Choose File > New Workbook, select a cell in the new sheet, and choose Edit > Paste.
Select the pasted data, including the headings, then choose a chart type from the Insert tab.
Select the new chart and choose Chart Design > Select Data. Check the series names and edit them if the dialog provides an edit option.

Change the chart series names in the original workbook
Use this method if the source headings or series name controls are editable.
Create and edit charts with WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and charts. Its Excel format compatibility makes it easier to move existing workbooks, although it does not repair Excel for Mac itself.

Frequently Asked Questions
Why does my Excel chart say Series 1 instead of a column heading?
The chart may not be using the heading cell as its series name. Check the source data and select the chart, then open Chart Design > Select Data to inspect the series.
Where can I change a legend name in Excel for Mac?
Select the chart and choose Chart Design > Select Data. Select the relevant series and use the Edit option to change its name if that option is available.
What if Select Data will not let me edit a series name?
Copy the source data and headings into a new workbook, create a new chart, and check its series names. If editing works there, the original workbook may have a compatibility or internal issue.
Can I use another file format to move the data?
You can save or export data in a supported format and import it into a new workbook. Check the format's limitations first: CSV, for example, does not retain charts or multiple worksheets.




