How To Set Chart Filters In Excel?
Filter data in your chart Click anywhere in your chart. Click the Chart Filters button. On the Values tab, check or uncheck the series or categories you want to show or hide. Click Apply. If you want to edit or rearrange the data in your series, click Select Data, and then follow steps 2-4 in […]