Question
2 On the Sales worksheet, with cell A1 selected, click the Power Pivot tab, and then in the Tables group, click Add to Data Model.
2 | On the Sales worksheet, with cell A1 selected, click the Power Pivot tab, and then in the Tables group, click Add to Data Model. |
3 | Close the Power Pivot for Excel window. Click the SalesReport worksheet. Merge the cells B1:Q1. Type Paper Mill Sales Report in cell B1 and apply the Title cell style to the text. |
4 | Insert a PivotChart into the worksheet using the workbook's Data Model as the source. Move the PivotChart so that the upper-left corner of the chart is in cell B2 and the lower-right corner of the PivotChart is in I16. |
5 | Add 2021 Sales as the Value and Month Order as the Axis. Ensure the chart is a Clustered Column chart. If necessary, remove the legend. Add the chart title 2021 Monthly Sales to the PivotChart. |
6 | Insert a second PivotChart into the worksheet using the workbook's Data Model as the source. Move the PivotChart so that the upper-left corner of the chart is in cell J2 and the lower-right corner of the PivotChart is in Q16. |
7 | Add 2021 Sales as the Value and Month Order as the Axis. Add Region as the Legend. Change the chart type to a Line chart. Add the chart title 2021 Monthly Sales by Region to the PivotChart. |
8 | Insert a PivotTable into cell B18 on the worksheet using the workbook's Data Model as the source. Add State as the Row and 2021 Sales for the Values. Remove the Grand Totals for both Rows and Columns. Convert the PivotTable to Formulas. |
9 | Insert a Filled Map Chart using the converted PivotTable. Type 2021 Sales by State as the chart title. Move the Chart so that the upper-left corner of the chart is in cell B18 and the lower-right corner of the Chart is in I32. |
10 | Select the 2021 Monthly Sales PivotChart. Insert a slicer for State. Adjust the Slicer to be 2 columns wide. Move the Slicer so that the upper-left corner of the chart is in cell J18 and the lower-right corner of the Slicer is in L26. |
11 | Hide the Gridlines and Headings on the worksheet. |
any help. it wont let me post the excel sheet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started