Question: Need Help. Step by step please. Insert a PivotChart based on the new PivotTable as follows to help Marina visualize the data: a . Insert

Need Help. Step by step please. Insert a PivotChart based on the new PivotTable as follows to help Marina visualize the
data:
a. Insert a Combo PivotChart based on the Payments by State PivotTable.
b. Display the Total Payments as a Clustered Column chart and the Average Payment
as a Line chart.
c. Include a secondary axis for the Average Payment data.
d. Hide the Field List so that you can format the value axis of the chart.
e. Change the maximum bounds for the value axis on the left to 1,400.
f. Change the PivotChart colors to Monochromatic Palette 4.
g. Resize and position the chart so that it covers the range D3:J17.
h. Display the Field List again.
 Need Help. Step by step please. Insert a PivotChart based on

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!