Problem: You work for RealQuick Connect and help the fi nancial director prepare and analyze revenue and expenses. He has asked you to create two PivotTables and corresponding PivotCharts based on sales data. One PivotTable and PivotChart summarize the sales by Supplier (Figure 8 – 96a). The other PivotTable and PivotChart summarize the computer sales by month for the top computer supplier (Figure 8 – 96b).
I have posted pictures of the instructions on how they appear in the book. I also posted the excel worksheet that you begin with.