Select your chart type.
Example of legend in excel. You can update Legend Entries and Axis Label names from this. This will open the Chart Elements popup. The main reason why a legend is in the Excel chart is to explain what type of data is being displayed in any of the colors.
Click and Select the Chart. Every Chart you create will automatically include a Legend section. Legend contains a simple square that shows the descriptive text and the color.
Labels should be used instead. How to Remove a Legend in Excel. From here uncheck the Legend Box.
This legend has been resized to a 3 row by 2 column grid. The legend will then appear in the right side of the graph. The legend will show which color in the Chart.
Click on the chart so that it will be highlighted as below. From the Legend drop-down menu select the position we prefer for the legend. This simultaneously changes the format of every point in the series associated with this legend entry.
Follow the below steps. If we want to remove the legend from the chart. Type anything in it.