How to change the legend in Excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-change-the-legend-in-Excel.png)
When you create a chart in Excel with multiple sets of data, it is standard practice to include a legend so that the viewer understands the data being displayed. Excel provides options to change the legend.
Step 1 – Open the Format Legend menu
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-change-the-legend-in-Excel.png)
– Select the legend
– Right-click and select Format Legend from the context menu
Step 2 – Change the legend
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-change-the-legend-in-Excel.png)
– Change the position of the legend
Step 3 – Change the text
![](https://spreadcheaters.com/wp-content/uploads/Step-3-How-to-change-the-legend-in-Excel.png)
– Change the column names
Step 4 – View the result
![](https://spreadcheaters.com/wp-content/uploads/Step-4-How-to-change-the-legend-in-Excel.png)
– Check that the legend is displayed as intended
Alternate access to the Format Legend menu
![](https://spreadcheaters.com/wp-content/uploads/Alternative-How-to-change-the-legend-in-Excel.png)
– Select the chart
– On the Chart Design menu, go to Add Chart Element > Legend > More Legend Options