Click on the chart so that it will be highlighted as below.You can download this Legend Chart Excel Template here – Legend Chart Excel Template If we observe, A and B represent two different colors, and the bars also represent the same color for 2011,20.
The Legend will be created automatically when we create a chart in excel. In the below chart, the keys A and B are highlighted with a red color box which is called Legend. The below-suggested chart box will open. Choose any one chart from the available charts. After that, select the Recommended charts option. We will insert a chart by selecting the data and clicking on the Insert menu button at the top.
Consider a small table which represents the sales of A and B for the year 2011, 20. Now we will create a small chart and perform different actions on legends. Select the chart and choose filter then you will see the categories and series.Įach legend key will represent a different color to differentiate from the other legend keys. The data in a chart is organized with a combination of Series and Categories. By default, it may show on the bottom or right side of the chart. Excel functions, formula, charts, formatting creating excel dashboard & othersĪ Legend is a representation of legend keys or entries on the plotted area of a chart or graph, which are linked to the data table of the chart or graph.
