How to use chart legends in Excel 2010 lynda.com tutorial

for which is a chart legend used This is a topic that many people are looking for. star-trek-voyager.net is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, star-trek-voyager.net would like to introduce to you How to use chart legends in Excel 2010 lynda.com tutorial. Following along are instructions in the video below:

“Most charts should contain legends to help explain what chart elements refer to you need need to know how to remove a legend how to add a legend on those that don t have them edit or reposition legends. Within a chart as well pretty easy stuff here. And you can achieve these objectives. A couple different ways and this chart.

There s a legend on the right hand side..


And that s just fine. That s the default location. I think that s where we re 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 wright 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 board or put it where 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 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 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 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 legend just by clicking on it and pressing delete again most of the time you probably do on a legend. But there are certain pie charts. When you might have applied data labels even bar charts where the labeling contains all the information that the legend of might so it s easily added and if we simply want to add a 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 ll recognize some that have legend on the bottom two for example this one so you see different options..


There are different ways to control the ” ..

Thank you for watching all the articles on the topic How to use chart legends in Excel 2010 lynda.com tutorial. All shares of star-trek-voyager.net are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.
description:

tags:

Leave a Comment