Get more Excel tips; How to add color to an Excel drop-down list. If you’ve used data validation controls, you know how easy they are to add and how helpful they can be.

How to Add an Overlay to Excel. Microsoft Excel 2010 can create a chart to illustrate numeric data from a worksheet. Excel's "Chart Tools" contain "Labels" that customize the chart area.

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.