Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to Change Legend Name in Excel on Mac
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
Select the chart, click the plus sign Plus in the upper-right corner of the chart, and then select the Legend check box.
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
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
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.
Also Read:
- 1. How to make First Name and Last Name in Excel Using Formula
- 2. How to change legend name in excel pie chart
- 3. Create unique name tags with a name tag template Word
- 4. Name Box: How to add table name in Excel
- 5. Name Manager: A Quick Way to Name a Cell in Excel
- 6. How to change or edit legend text in excel