Question

You have created a PivotChart showing sales by quarter by sales rep. Before presenting it to management, you notice thename of a rep who has since been fired. How do you remove this rep from the chart without deleting the data?(a) Filter the Sales Rep field in the PivotChart and deselect the employee's check box.(b) Make the employee’s data points and axis titles invisible.(c) You can‘t delete the rep from the chart without first deleting the data.(d) Hide that rep‘s row(s) in the underlying list, which automatically removes that rep from the chart.

Answer 1

Answer:

This rep can be removed from the chart without deleting the data. a) Filter the Sales Rep Field in the PivotChart and deselect the employee's checkbox.