Question

Q1:

Switch to the Region PivotChart worksheet. Because Anita wants to compare all of the product order amounts, change the PivotChart filter to display data for all dates, not just for March.

How and what are the steps to create this chart in Excel?

Q2:

Because the worksheet will print on three pages, Noah thinks it best to display the first and last names and the reunion year on each printed sheet. Add the range A:C as print titles that repeat at the left of each printed page.

Answer 1

1. click on the any cell inside the pivot table and than on the analyze tab , in the tools group click on the pivot chart and you can apply a standard filter to diplay data for all dates.