In each category we have only one set of data so no need of legends here.
Example of legend in excel. The above chart is a single legend ie. Copy your most-important colors from the GS data table and paste them in the Legend sheet. Add legend to an Excel chart.
From the Legend drop-down menu select the position we prefer for the legend. Click on the chart so that it will be highlighted as below. The associated series must.
From here uncheck the Legend Box. Now go to Insert Textbox ALTNX in Excel 2007. Legend contains a simple square that shows the descriptive text and the color.
The following example changes the marker background color for the legend entry at the top of the legend for embedded chart one on the worksheet named Sheet1. Type a description of each color in the adjacent cell. Whenever you create a chart in Excel a legend for the chart is automatically generated at the same time.
This simultaneously changes the format of every point in the series associated with this legend entry. Select first text box. Well make the change and in the legend we can see that the color next to Asia has also changed to green.
How to show Excel legends on Chart. Every Chart you create will automatically include a Legend section. Add a new sheet and name it Legend.