Pie Chart

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?