Learn how to add a legend to a chart, retrieve a missing legend, and adjust its settings. Add, edit, or remove a chart legend in Excel.

Click the chart to which you want to add a legend, click the Chart Elements button , and then click Legend. To change the location of the legend, click the arrow next to Legend and then click …

You can hide or show the legend of a chart. You can also show a data table for a line chart, area chart, column chart, or bar chart.

Learn how to add a legend to a chart, retrieve a missing legend, and adjust its settings. Add, edit, or remove a chart legend in Excel.

On the worksheet, click the cell that contains the name of the data series that appears as an entry in the chart legend. Type the new name, and then press ENTER.

On a chart, click the data label in the data point that you want to change, and then click the data label again to select just that label. Click inside the data label box to start edit mode.

Click on the chart. On the ribbon, click Chart Design and then click Select Data. This selects the data range of the chart and displays the Select Data Source dialog box. To edit a legend …

Select the chart element (for example, data series, axes, or titles), right-click it, and click Format <chart element>. The Format pane appears with options that are tailored for the selected chart …

Here are step-by-step instructions for the some of the most popular things you can do. If you want to know more about titles in data labels, see Edit titles or data labels in a chart.

You can use a keyboard and screen reader to add a title, data labels, and a legend to a chart in Excel.