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 the …

To add a new legend entry, type the reference to the worksheet cell or type a new name and then, in the Series values box, type a reference to the data series on the worksheet that you want to use for the …

Change or create legend names for an Excel chart by editing the legend name cells or using the Select Data option.

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.

Add data labels to a chart Click the data series or chart. To label one data point, after clicking the series, click that data point. In the upper right corner, next to the chart, click Add Chart Element > Data …

Add a data series to a chart in Excel. Show a new data series in your chart (graph) by including the series and its name in the chart source data.

In a chart you create, axis labels are shown below the horizontal (category, or "X") axis, next to the vertical (value, or "Y") axis, and next to the depth axis (in a 3-D chart). Your chart uses text from its …

This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Layout tab, in the Labels group, click Data Labels, and then click the option that you want.

Right-click the chart with the data series you want to rename, and click Select Data. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit.