How to Make Pie Chart in Excel

Microsoft Office's Excel application is more than just a spreadsheet for storing and organizing data. Excel has functions that help users render charts and graphics to convey data visually. Pie charts express the individual parts that compose a whole--similar to how after a pizza is sliced you can see how many pieces are available for serving. If you have data parsed into individual values to make a whole you can create an effective pie chart in Excel.

...
Pie charts are graphical representations of percentages of a whole.

Create a Table of Data

Step

Click cell A1 and type a descriptive header for your data--for example, "Salesperson." Click cell B1 and type a descriptor for the numerical data--for example, "Sales in Dollars."

Step

Type the corresponding data in the cells below the headers. For example, cells A2 and B2 might say "Jane" and "1000," respectively.

Step

Skip down to the next row, and enter another data-set in cells A3 and B3, and so on. Enter one data record per row.

Create a Pie Chart

Step

Highlight the data set by clicking on cell A1, holding the mouse button down and dragging the cursor to encompass all of the data in the table. For example, if your table has 2 columns and 10 rows, highlight all cells from A1 to B10.

Step

Click on the "Insert" tab at the top of the application window.

Step

Click on the "Pie" button in the "Charts" section and choose either a 2-D or a 3-D style. Wait while Excel creates your pie chart directly on the spreadsheet that holds your table of data.

Step

Hover your cursor over the newly created pie chart until you see the four-way cross with pointed arrows. Adjust the position of your pie chart if it is hiding your table of data.