Adding, editing, and removing legends

Although most charts should contain legends to help explain what the chart…elements refer to, there are times when you want to remove a legend, particularly if…there is only one series--you might have that same information embedded in a title.…You also need to know how to edit a legend, how to move it around, or…reposition it anywhere on the chart you might wish, or possibly put it under or above the chart.…There are a number of different ways to do this.…You do have control over the legend.…In the chart that we are seeing right here, a legend is in it's most customary…position on the right-hand side of a chart.…

Now remember, when you do select a chart you have an option here are on the…Layout tab, if you go to Legend--…it's in the Labels group here--to reposition the legend at various locations here.…This is certainly one approach. Let's put it on top.…See how that looks. Maybe that looks pretty good,…so we'll come back up here again,…Show Legend at left.…Less common by far, Bottom, and Overlay legend, don't forget these two.…

Resume Transcript Auto-Scroll

Author

Released

6/15/2011

In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.