Remove Series From Charts

Remove Series from Active Chart without Clearing Entire Chart

1.Uncheck one or more legends to be removed in the active chart.

2.Click the Advanced tab and modify DeleteSelectedSeries of Misc from False to True.

Remove Series from All Charts without Clearing

1.Uncheck one or more legends to be removed in the active chart.

2.Click View > Advanced > All {...} Series in the toolbar above the active chart.

Note: It selects all the series with the unchecked legends in all of the charts, checks the legends back or makes them visible again, and opens the Advanced tab for users to edit.

3.Modify DeleteSelectedSeries of Misc from False to True in the Advanced tab.