Question: Heatmap From the data table for Orders, create a pivot table on a new sheet. Call the sheet Day - Region Orders and move it

Heatmap
From the data table for Orders, create a pivot table on a new sheet. Call the sheet "Day-Region Orders" and move it to the right.
The pivot table in the Day-Region Orders sheet should show the count of orders per day of the week (on rows) and regions (on columns).
Make a copy of the pivot table placing its top-left corner on cell A15. This is the table to present.
Apply conditional formatting from Green to White to the group of cells showing the number of orders per day per region.
Add an informative title and an indication of what the color intensity of the cells means.
Make sure that all --and only-- the informative labels and visual elements are present. Aka, declutter and focus.
 Heatmap From the data table for Orders, create a pivot table

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!