You have created a PivotChart showing sales by quarter by sales rep. Before presenting it to management, you notice the name of a rep who has since been fired. How do you remove this rep from the chart without deleting the data?
a.
Make the employee's data points and axis titles invisible.
b.
Hide that rep's row(s) in the underlying list, which automatically removes that rep from the chart.
c.
Filter the Sales Rep field in the PivotChart and deselect the employee's check box.
d.
You cannot delete the rep from the chart without first deleting the data.
Answer: c.
Filter the Sales Rep field in the PivotChart and deselect the employee's check box.
If the answers is incorrect or not given, you can answer the above question in the comment box. If the answers is incorrect or not given, you can answer the above question in the comment box.