You should have many more colors and the frequencies should be based on what you count (for each color) from the main spreadsheet that I provided.
- Once completed, highlight all of the cells of your completed frequency table, by selecting and dragging your pointer through all of the cells.
- Select on Insert, and then Recommended Charts.
- Click to select the Pie Chart.
- Select on the pie slices, right-click Add Data Labels, and select Add Data Callouts. Select appropriate labels for your pie wedges.
- Add an appropriate title for your overall pie chart. (For some of you, the options to add titles and format your pie chart are located in your toolbar(s); so, explore your own version of Excel)
- Save the worksheet to your computer and upload your file.