Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

American Public School Finance

Authors: William A. Owings, Leslie S. Kaplan

1st Edition

0495807834, 9780495807834

More Books

Students also viewed these Finance questions

Question

=+c. Now rewrite the sales message. The daily

Answered: 1 week ago

Question

=+How can you use this information to develop a better opening?

Answered: 1 week ago