How to Filter Charts in Excel
You may occasionally want to turn off certain parts of your chart, to focus in on specific data. This can be accomplished with filtering.
All the data remains in the worksheet, but only the selected values appear in the chart.
When you need to see all your data again, clear the filter.
Clicking the check box once deselects everything. Clicking it again turns everything on again.
Free to distribute with our compliments; we hope you will consider our paid training.