Question

Date Total Order Amounts Product Order Amounts per Region $560.00 $540.00 $520.00 $500.00 O Product Starter Set Grill Set $480.00 $460.00 5440.00 $420.00 Southwest Southeast Region - roducts Monthly Sales Region PivotChart Regions Discounted Price Product Pricing

Question #8 please

Answer 1

In Pivot Charts we are provided with filters in the chart so that we can apply the required filter and change the chart accordingly.Note changing filter in pivot chart also changes pivot table accordingly.

In the Region PivotChart worksheet we want to see the data for all dates so we change the filter of the date in upper left corner of pivot chart.

Select the drop down in Date field of upper left corner and select all option there , then click ok.

Now after this operation you will be able to see all dates data and not just the data for the month of March.

Now if you want data for everything do the same operation of selecting all and clicking ok for region as well as product drop down provided

Hope this helps. Thank You.