Labels should be used instead.
Example of legend in excel. The legend will then appear in the right side of the graph. 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.
Either enter the range of cells manually or press the small button to the right of the range box. This program is an example of creating a simple line chart with as legend. Click the Plus sign next to the Chart.
Learn how to add a border to the legend of a graph in Microsoft ExcelTo add a border to a legend begin by selecting the legend on your graph and navigating. Go to Insert and select Chart 3. Click the Layout tab then Legend.
If we want to remove the legend from the chart. For example the entries for one and two are side by side. Assign legend message cells to text boxes.
Select your chart type. Click anywhere on the chart. Follow the below steps.
The above chart is a single legend ie. This will open the Chart Elements popup. Legend contains a simple square that shows the descriptive text and the color.