Question

How can you add and remove categories from a previously created chart? A. Click the Format tab. B. Click the Chart Styles button. C. Click the Chart Elements button. D. Click the Chart Filters button.

Answer 1

Click the Chart Filters button.

Answer 2

The answer is D: Click the Chart Filters button

Once you have created your chart, you can change the data series by using chart filters to hide or show data in your chart. To add or remove categories from a previously created chart, click anywhere in the chart filters button and select the Values tab to check or uncheck the categories you want to show or hide.