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 or edit legend text in excel

August 12, 2022
12.5K Views

 The various techniques of how to change or edit legends in Excel are the focus of this article. A chart's legends serve as indicators, indicating what each eye-catching label on the chart means. With legends on a chart in WPS Excel, you can accomplish a lot.

Following is the process of how to change or edit legend in excel.

How to hide or unhide legends in excel:

Here's how to show or conceal a chart's legends.

The chart area can be clicked anywhere.Select the green + icon for the chart elements.Legends can be hidden or revealed by checking or unchecking a box.

How to delete legends in chart in excel:

1.Do a right-click on the graph.Select Data by clicking it.

2.Click Remove under Legend Entries on the left side.A legend may also be deleted or eliminated in the following ways.

3.To erase a legend, double-click it.Do a right-click on it.

4.To remove just the legend, hit Delete.To remove the legend and the series, click Delete Series.

How to change legend positions on chart in excel:

These steps should be followed in order to move the legends on the chart.

1.To move the legends on the chart, pull on the black arrow.

2.In the Format Legends window pane on the right, click More Options to access additional position settings for your legends.

The following is another method of moving legends around.

1.On any part of the chart, click.Select the Design tab.

2.Pull down on Add Chart Elements under Chart Layouts.

3.Select your preferred position from the Legends.

How to edit or change legend name in excel:

Here are some methods you can use to change the names of your legends.

1.Do a right-click on the graph.Select Data by clicking it.

2.Look under Legend Entries on the left.

3.Choose the legend whose name you want to alter.

4.Click on edit.Under Series Name, type a new name for that tale.

The following is another method you can use to change the legend names.

1.On the chart, click.

2.Select the Design tab.Choose Select Data

3.Now, modify each legend's name as described in the previous steps.

How to format legend text in excel:

The legend texts can even be formatted in terms of alignment, angles, or direction. The steps to format legends are listed below.

1.The legend texts should be clicked twice.

2.The Format Legend window opens in the right corner.

3.Next to Legend Options, select Text Options.

4.Select Textbox by clicking the third icon.

5.Under Text Direction, choose the text direction you prefer.

Note: This above written article is an attempt to show you how to change or edit legend text in excel online, 2016 and 2019, in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.    
                               

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