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 font used …

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 …

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.

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

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 automatically when …

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

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.

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 percentages, …

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.