In a chart where is the legend located

By default, it may show on the bottom or right side of the chart. The data in a chart is organized with a combination of Series and Categories. Select the chart and choose filter then you will see the categories and series. Now we will create a small chart and perform different actions on legends.

Consider a small table which represents the sales of A and B for the year , and We will insert a chart by selecting the data and clicking on the Insert menu button at the top. After that, select the Recommended charts option. The below-suggested chart box will open. Choose any one chart from the available charts. Click the "Charts" tab on the ribbon, click "Chart Layout," click the "Legend" button, and then click "Legend Options" to load a list of customizable options for your legend.

Click the "Font" tab to customize the font. Click the "Placement" tab to change where the legend appears on the chart. Depending on the type of chart, the legend keys represent different groups of data in the accompanying worksheet :. In Excel, legend keys are linked to the data in the plot area, so changing the color of a legend key will also change the color of the data in the plot area. You can right-click or tap-and-hold on a legend key, and choose Format Legend , to change the color, pattern, or image used to represent the data.

To change options related to the whole legend and not just a specific entry, right-click or tap-and-hold to find the Format Legend option. This is how you change the text fill, text outline, text effect, and text box. After making a chart in Excel, it's possible that the legend doesn't automatically show.

You can enable the legend by simply toggling it on. Here's how:. Select your existing chart. Select Design. Select Add Chart Element.

Select Legend. Choose where the legend should be placed — right, top, left, or bottom. If the option to add a legend is grayed out, it just means that you need to select data first. Right-click the new, empty chart and choose Select Data , and then follow the on-screen instructions to choose the data that the chart should represent.

Improve this question. Add a comment. Active Oldest Votes. Looks to me like it hasn't been used with regards to maps until the early twentieth century. Improve this answer. Goodies Goodies 1 1 silver badge 5 5 bronze badges. Good to learn. Reference link, please? My apologies: etymonline.