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 box, ...

I select columns A-H in my spreadsheet and use the filter. I can now sort and filter the data by the various columns: This dialog box lets me sort the data by rows, or display only some rows to look ...