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.
Create a Table of Data
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."
Type the corresponding data in the cells below the headers. For example, cells A2 and B2 might say "Jane" and "1000," respectively.
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
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.
Click on the "Insert" tab at the top of the application window.
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.
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.
Tips & Warnings
- Use the "Chart Tools" tabs to make further changes to the pie chart, such as design, layout and format.