MS Excel and Chocolate !
You now have enough information on your spreadsheet to do a Pie Chart.
Why a Pie Chart? Because a pie chart is useful for displaying information that relates to the whole. In this case like how for instance red M&Ms relate to whole package.
Using Chart Wizard info
Click the Chart Wizard Tool (circled above)
Then Select Pie Chart and then any of the Chart sub-types
Click Next...Make sure Series in Columns is check off... as data is presented in a column for our example.
On Step Three of the Wizard Click the Data Labels Tab
and check off Show Label and Percent and Click Next and Finish !
Now View your results !
Note you can now edit your chart to look better. For instance you can select each slice and then double click it. This will bring up a color picker from which you can select Red for Red and Orange for orange etc.
Pretty cool, huh?