How to Change Legend Name in Excel on Mac
A free Office suite fully compatible with Microsoft Office
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
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.
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.
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to add text to beginning or end of all cells in Excel
- 5. How to color cell based on value in Excel?
- 6. How to compare two excel sheets and highlight differences