Load the Excel worksheet containing the chart you want to edit. Click the chart into which you want to insert a legend. Click the "Charts" tab on the ribbon to load the Charts group. Click the ...

Click one of those colors, and Excel applies it to the legend instantly. This flexibility gives you the ability to see how different legend colors look in relation to existing chart elements.

If you notice that the Legend of the chart is missing, and you want it to be in the chart, click the chart and click the Chart Elements button and check the Legend checkbox from its menu.

Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.