Output: How to rename legend Change legend name The legend name is immediately changed to “A”.įigure 8. Delete the current entry “=Sheet1!$C$2” in series name and enter “ A ” into the text box. Right-click anywhere on the chart and click Select Dataįigure 4. There are two ways to change the legend name: The legend in a chart can be edited by changing the name, or customizing its position and format. The legend will then appear in the right side of the graph. From the Legend drop-down menu, select the position we prefer for the legend When we encounter an Excel chart without a legend, we can easily add a legend through these steps: Add legend to an Excel chart
In the chart above, the legend is located in the top center of the graph, showing a bulleted list with text “A” and “B Sales”. Legends are automatically created everytime we create a graph or plot our data.įigure 1. The key to understanding charts is through the use of legends.
