1. Create a chart showing your cumulative revenue to date per product.
2. Create a chart showing your quarterly revenue for each product.
3. Create a chart showing your daily revenue for quarters 1 and 2. (Since this chart is showing daily values, represent this as a line chart.)
4. Create a chart showing your cumulative revenue to date per region of the country.
5. Modify chart 4 so that it shows this data per quarter for all quarters to date. (Summarize the data at the quarterly level.)
6. Create a chart showing your daily cumulative net income. (Hint: see note on chart 3.)
7. Create a chart showing your daily cumulative cost of goods sold.
8. Create a chart that compares the Total Finished Products Produced and the Total Finished Products Sold on a daily basis for quarters 1 and 2.
9. Create a chart that shows the daily inventory levels for all products. (Note that this chart is likely very hard to read.)
10. Change chart 9 so that it just focuses on two products with an interesting inventory history.
11. Create a chart that shows your daily production for quarters 1 and 2.
dhyaa22
lab7-excelaccesspivotcharting.docx
0
