Step 1 To reorder the bars, click on the chart and select Chart Tools Under the Data section, click Select Data Step 2 In the Select Data Source pop up, under theTo edit a legend series, in the Legend entries (series) box, click the series you want to change Then, edit the Name and Y values boxes to make any 1 – How do I remove all but one 'data series label' in the legend?On the menu displayed, click Select Data In the Legend Entries, select the data series you want to rename, and click Edit In the Edit Series dialog box, clear series name, type the new series name in the same box, and click the OK The name you typed (new name) appears in the chart legend, but won't be added to the Excel worksheetSelect your chart in Excel, and click Design > Select Data Click on the legend name you want to change in the Select Data Source dialog box, and click Edit Note You can update Legend Entries and Axis Label names from this view, and multiple Edit options might be available Type a legend name into the Series name text box, and click OK
How To Make A Pie Chart In Excel Contextures Blog