art 4 - Dashboard - Pivot Tables 1. Now you want to produce a visual review of equipment usage, looking at several different metrics. This is called a Dashboard. On a tab labeled Dashboard, create four pivot charts - one for each item below. This time as you create the second chart and when asked where you want the chart to be placed, you will select "existing sheet" rather than a new sheet. Arrange these pivot tables / charts in a pleasing manner that will fit on one page. a. Equipment inventory pie chart showing equipment counts by equipment types. b. Column chart with average utilization by equipment type. c. Bar chart with the amount billed by equipment type. d. Combo chart displaying average hourly rate and average surcharge billed by equipment type. 2. Include the data along with the charts in your dashboard. a. This dashboard is meant to be an attractive visual. Don't just create the charts and walk away. Make your presentation interesting and engaging to the ey