Question: Create a Pivot Chart on a new sheet to the right of Volume per Timeframe called Profitability. This pivot chart should show which regions (names,

 Create a Pivot Chart on a new sheet to the right

Create a Pivot Chart on a new sheet to the right of Volume per Timeframe called Profitability. This pivot chart should show which regions (names, not ids) generated the most profit from overall avocado sales. Assume that the cost (to the seller) of a conventional avocado is $1.00 and the cost of an organic avocado is $1.50. Place the chart stretching from cell A1 to T30. Have the chart show only the top 10 highest profit regions and add a date filter show it can switch between years. Give the chart an appropriate title and axis labels. Add data values and format them as black text, bold, and as currency. In cell A31, state which region had the highest cells in 2015 and the value. For example: "In 2015, Nashville had the highest profit at $4,963,097.94" (this is not true, just an example). Do the same in cells A32 for 2016, A33 for 2017, and A34 for 2018

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 General Management Questions!