Saturday, December 17, 2011

How to Create a Pie Chart in Excel That Illustrates a Portion That Contributes to a Total


1. Open Microsoft Excel. Click into the first cell on the spreadsheet, A1. Type the first sector of items to calculate for the pie chart, such as 'Cats.' Press the 'Enter' key to drop to the next cell, A2. Type the next item, such as 'Dogs.' Continue entering items until all are listed.
2. Click into cell B1. Type the number to use for the pie chart calculations, such as '100.' Press the 'Enter' key to drop into cell B2 and type the number corresponding with the entry in column A. Repeat until all of column A's cells have numbers in column B.
3. Highlight all of the cells you just entered. Click the 'Insert' tab at the top of the workspace.
4. Click the drop-down arrow below the 'Pie' chart button. Click the second button under '2-D Pie,' which is the exploded pie and looks like a Pac-Man. Excel automatically produces a pie chart showing portions of the pie contributing to the total pie.

Blogger news