- Use the COUNTIF function to count the number of shirts of each design that were sold.
- Format the calculations into a table.
- Insert a pie chart to visually represent the data.
- Add the chart to its own sheet and protect it.
- Repeat the same steps for shirt styles.