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.

Steps for adding and changing the look of a chart legend in Office 2016 for Windows, including customizing the border, the background of the chart legend, and changing and resizing 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 …

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.

To quickly identify a data series in a chart, you can add data labels to the data points of the chart. By default, the data labels are linked to values on the worksheet, and they update …

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

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.

To make a chart easier to understand, you can add chart titles and axis titles, to any type of chart in Excel, Outlook, PowerPoint, or Word.

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

For example, in the pie chart below, without the data labels it would be difficult to tell that coffee was 38% of total sales. You can format the labels to show specific labels elements like, the …