Join Dennis Taylor for an in-depth discussion in this video Adding, editing, and removing legends, part of Excel 2010: Charts.
Although most charts should contain legends to help explain what chart elements refer to, you need to know how to remove a legend, how to add a legend on those charts that don't have them, and edit or reposition legends within a chart as well. Pretty easy stuff here and you can achieve these objectives a couple of different ways. In this chart, there is a legend on the right-hand side and that's just fine. That's the default location. I think that's where we are used to seeing a legend. However, if we select this chart and go to the Layout tab, we can choose the option Legend, and instead of showing it on the right, show it on top. Sometimes that looks better. Personal choice of course. On the left, and without going through every single one of these, you get the idea.
You might notice the last two here. Overlay Legend at Right, certainly not a good choice here. Overlay on the Left. Maybe more so. No matter where the legend does end up, you can click and drag it. We could have done that from the beginning before even going into the menu, but you can click and drag this. Usually just click on it, drag a border, put it wherever you want. And if you want to leave it there, that's fine. A good follow-up on this would be to give it a background color, zip out to the to the Format tab perhaps, choose one of these options, pop a color on it. There we go. And if you have to see those ahead of time, you can certainly do this. [00:01:134.15] Drag it around and explore what those might look like. So, easy to handle.
If the legend is larger, if it encompasses more entries than this one, sometimes what you will want to do to possibly is resize this. If we had four entries there it might do this or stack them up two by two and so on. So you can resize the legend as well. And you can certainly get rid of a legend just by clicking on it and pressing Delete. Again, most of the time you probably do want a legend, but there are certain pie charts when you might have applied data labels, even bar charts or the label that contains all of the information that the legend might. So it's easily added. And if we simply want to add legend right after we create a chart, it's not a bad idea to go to the Design tab and choose one of the Chart Layout options that has legends in it, and at the same time pick up on the titles as well.
Many of these have legends on the right-hand side. After you get used to this particular feature you will recognize some of that have the legend on the bottom too, for example this one. So you see different options there, different ways to control the placement of a legend on a chart.
Author
Released
6/15/2011- Identifying the plot area, chart area, gridlines, legends, and more
- Selecting the right chart type
- Creating charts instantly with shortcuts
- Choosing a layout
- Dealing with empty and hidden cells
- Switching rows and columns for a different view of the data
- Moving and resizing a chart
- Inserting pictures and shapes
- Adding labels to a chart
- Analyzing existing and future data with trendlines
- Changing a chart's data source
- Printing charts
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2010: Pivot Tables
with Curt Frye3h 43m Intermediate -
Excel 2010: Advanced Formatting Techniques
with Dennis Taylor3h 2m Intermediate -
Managing and Analyzing Data in Excel 2010
with Dennis Taylor1h 32m Intermediate -
Excel 2010: Data Validation
with Dennis Taylor59m 38s Intermediate
-
Introduction
-
Welcome1m
-
-
1. Understanding Excel Chart Concepts
-
2. Creating Basic Charts Quickly
-
3. Fine-Tuning Charts with Design Tab Choices
-
Choosing a chart layout3m 22s
-
4. Layout Tab Options: Inserting Pictures, Shapes, and Text Boxes
-
Adding shapes and arrows2m 58s
-
5. Layout Tab Options: Adding Titles, Labels, and Legends
-
Linking titles to content1m 52s
-
6. Layout Tab Options: Using Axes and Gridlines
-
Modifying axis scaling7m 55s
-
Working with gridlines4m 11s
-
-
7. Layout Tab Options: Using the Analysis Tools
-
Adding drop lines1m 11s
-
Adding error bars4m 34s
-
8. Format Tab Options: Adding Shapes and WordArt Styles
-
Adding shape effects5m 34s
-
Applying WordArt styles2m 1s
-
9. Using Other Formatting Tools
-
Formatting lines and borders3m 45s
-
Working with chart text2m 47s
-
-
10. Adjusting Specific Chart Types
-
Using column and bar charts9m 12s
-
Using line charts5m 25s
-
Using pie charts6m 30s
-
-
11. Changing a Chart's Data Source
-
12. Printing and Sharing Charts
-
Printing charts6m 41s
-
-
Conclusion
-
Next steps43s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Adding, editing, and removing legends