Skip to main content
Microsoft
Support
Support
Sign in
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Excel for Microsoft 365 Word for Microsoft 365 PowerPoint for Microsoft 365 Excel for Microsoft 365 for Mac Word for Microsoft 365 for Mac PowerPoint for Microsoft 365 for Mac Excel 2021 Word 2021 PowerPoint 2021 Excel 2021 for Mac Word 2021 for Mac PowerPoint 2021 for Mac Excel 2019 Word 2019 PowerPoint 2019 Excel 2019 for Mac Word 2019 for Mac PowerPoint 2019 for Mac Excel 2016 Word 2016 PowerPoint 2016 Word 2013 More...Less
WindowsmacOS
-
Click the chart to which you want to add a legend, click the Chart Elements button
-
To change the location of the legend, click the arrow next to Legend and then click the location that you want.
Tips:
-
By default, a legend does not overlap the chart. If you have space constraints, you may be able to reduce the size of the chart by clicking More Options and then clearing the Show the legend without overlapping the chart check box.
-
To remove a legend, right-click it, and then click Delete.
Once you add the chart legend, there are many things that you can do to change how it looks.
Change font or font size
-
Right-click the legend, and then click Font.
-
On the Font tab, make the changes that you want to the font or font size.
Change legend border or background
-
Right-click the legend, and then click Format Legend.
-
In the Format Legend task pane, pick the options that you want.
Tip:You can really make your legend stand out by adding an effect. Click Effects and then pick the effect that you want. A wide variety of effects is available, including shadows, glows, and soft edges. (Just be careful not to go overboard: you probably don't want to clutter the presentation of your data.)
A legend can make your chart easier to read because it positions the labels for the data series outside the plot area of the chart. You can change the position of the legend and customize its colors and fonts. You can also edit the text in the legend and change the order of the entries in the legend.
-
On the View menu, click Print Layout.
-
Click the chart, and then click the Chart Design tab.
-
Click Add Chart Element > Legend.
-
To change the position of the legend, choose Right, Top, Left, or Bottom. To change the format of the legend, click More Legend Options, and then make the format changes that you want.
Depending on the chart type, some options may not be available.
Need more help?
Want more options?
Discover Community
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Microsoft 365 subscription benefits
Microsoft 365 training
Microsoft security
Accessibility center
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Thank you for your feedback!
×
