WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to Change Legend Name in Excel on Mac

February 13, 2023
14.0K Views

The data in the cell above each column or row of data is used as the legend name when you build a chart in Excel. You can alter legend names by changing the data in those cells, or you can use Select Data to modify the default legend name.

The caption for the above graph, which features a bulleted list with the phrase A Sales and B Sales, is situated in the top Centre of the graph.

These procedures make it simple to add a legend to an Excel chart that is missing one:   

Add legend to an Excel chart

Step 1.  Click anywhere on the chart

Step 2.  Click the chart tool tab, select Legend from drop down option

Step 3.  Select legend format option, select the position you prefer for the legend

Show the legend in your chart

  1. Select the chart, click the plus sign Plus in the upper-right corner of the chart, and then select the Legend check box.

  2. Click the black arrow to the right of Legend for options on where to place the legend in your chart.

 

Change the legend name in the excel data

  1. Select the cell in the workbook that contains the legend name you want to change.

2.Type the new legend name in the selected cell, and press Enter. The legend name in the chart updates to the new legend name in your data.

3.Certain charts, such as Clustered Columns, also use the cells to the left of each row as legend names. You can edit legend names the same way.

Change the legend name using select data

  1. Select your chart in Excel, and click Design > Select Data.

2.Click on the legend name you want to change in the Select Data Source dialog box, and click Edit.

3.Type a legend name into the Series name text box, and click OK. The legend name in the chart changes to the new legend name.

How to edit legend?

Legends can be customized by changing the layout, position or format.  

How to change legend position?

It is very easy to change the legend position in Excel.  Simply click the chart, then click the Layout tab.  Under Legend, choose the preferred position from the drop-down menu

.

Example:  

Select Show Legend at Top from the drop-down menu.  As shown below, the legend is transferred to the top of the chart.  

How to edit legend format?

In order to change the format, select the legend from drop down option and click Format button.  

The Format Legend dialog box will appear.  There are several options where we can change the legend position, fill, border color, border styles, and other formatting options.  

Example:  

We want to fill the legend box with Aqua, Accent 5, Lighter 60%.  

We click Fill, then tick Solid Fill.  

Did you learn about how to Name Table in Excel Spreadsheets? To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets and PowerPoint Slides

You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience. 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.