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.

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.

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 …

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 …

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

Learn how to create a chart in Excel and add a trendline. Visualize your data with a column, bar, pie, line, or scatter chart (or graph) in Office.

Using Microsoft Excel, you can quickly turn your data into a doughnut chart, and then use the new formatting features to make that doughnut chart easier to read.

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.

Once you’ve created a Map chart, you might want to take advantage of some of its powerful formatting features. Note: Map charts are only available in Excel 2016 if you have a Microsoft …