Chart & Visualization Issues

Change Excel Chart Legend Names on Mac

Elise WilliamsElise Williams Nov 14, 2026 868 views

Question details

The user wants to replace generic chart legend labels with meaningful series names in Excel for Mac.

How to Change Excel Chart Legend Names on 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.
Before you start

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.

Solution 1Recommended

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.

1
Copy the source data

Select the chart's source data and column headings in the original worksheet, then choose Edit > Copy.

2
Create a new workbook

Choose File > New Workbook, select a cell in the new sheet, and choose Edit > Paste.

3
Create a chart

Select the pasted data, including the headings, then choose a chart type from the Insert tab.

4
Check the legend names

Select the new chart and choose Chart Design > Select Data. Check the series names and edit them if the dialog provides an edit option.

Recreate the chart in a new Excel workbook
What the test means: If the names work in the new workbook, the original file may have a compatibility or internal issue. This test alone does not prove the file is corrupted.
Free Microsoft Office alternative

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.

Create charts from worksheet data and headingsOpen and save Microsoft Excel formats, including XLSXNavigate spreadsheets with a familiar interfaceUse a free, lightweight office suite
microsoft office alternative - wps office

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.