To turn your big data set into a PivotTable, select any cell in the range, and in the Insert tab on the ribbon, click the top ...

To remove the drop-down list, click the "Data" tab on the ribbon and click "Data Validation" to open the dialog box. Click the "Settings" tab and click the "Clear All" button.

A legend box in an Excel chart lists the chart's data series. It specifies each series' name and the color of its marker on the chart. When you try to edit a legend using the Format Legend dialog ...