WPS Office

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.

Free download

Windows • MacOS • Linux • iOS • Android


How to add legend in excel 2010

July 21, 2022

 The process for adding a legend to an Excel chart is quite similar to the process for removing one.

How to add legend in excel online, 2016 and 2019:

1. Click on the + icon in the top right corner of the chart after selecting it.

2. Give the Legend a checkmark from the pop-up menu.

3. Legend is now once more accessible.

4. If we look closely, the legend is now located on the right side of the chart rather than at the bottom.

How Can I Move the Legend in a Chart in excel?

We'll now look at how to maintain the Legend in the Excel chart in the appropriate place.

1. As usual, choose the chart. Click the plus sign.

2. If we observe, when you select legend from the pop-up menu, there is an arrow pointing to the right. On the right arrow, click.

3. You'll see a drop-down menu.

4. When we open it, the Right option is highlighted since our Legend is now on the right side. Let's say we want to maintain the legend on the top. Choose top, just as you would with Right, Left, and Bottom. We will select the Top option in this case.

5. So, it rose to the top as seen below.

6. The Legend has always been shown separately from the chart till now. Click on the More choices accessible on the Legend if we want to overlap the legend on the chart.

7. The format menu for the legend will display on the right side of the screen when we select More choices. With a check mark at the bottom of the Format legend, you may choose to display the legend without covering the chart.

8. Click on the tick mark to delete it if desired.

9. The Legend will then overflow the chart as seen in the image below.

What You Should Know About Legends in Excel Chart

  • The legend is the text that appears on the excel chart's plotted region.

  • Legend keys on it are associated with the data source.

  • When we insert a chart in Excel, the legend will immediately display.

  • By clicking the + sign, selecting the Legend option drop-down, and selecting the necessary choice from the drop-down, we may move the Legend to the top, bottom, right, and left of the chart as needed.

  • By selecting the filter option and changing the series name, legend key names may be modified.

  • The legend option may be disabled from the + symbol, or the legend can be selected and deleted if we wish to remove it from the chart.

Note: This article was an attempt to show you how to add legend in excel online, 2016 and 2019 in both windows and mac. 

To get the newest version of WPS Office, you must first access this operating interface.

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.