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 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
Get step-by-step solutions from verified subject matter experts
