How to Make Pie Graphs in Excel
Charts and graphs provide excellent means for which to represent data. Pie graphs are especially useful because they provide the viewer with a quick snapshot of the data that can be visualized with a single glance. However, it can be a bit of a pain to prepare a pie graph if you are trying to do so manually. Thankfully, there are software applications such as Microsoft Excel that take away this difficulty and make the preparation of pie graphs quick and easy. Read on to learn how to make pie graphs in Excel.
Things You'll Need
- Microsoft Excel
Enter the data that you want your pie graph to represent into a spreadsheet in Microsoft Excel. Make sure to include column headings that explain what the data signifies. Try to be as descriptive with your data entry as possible because these elements will automatically feed into the pie graph. To help explain, we will construct an example in which we create a pie graph that breaks down a favorite color list by percentage.
Click on the cell that contains your first column heading. Then, from the “Insert” menu, click on the arrow underneath the word “Pie” and the picture of a sample pie graph. Another menu will open.
Choose the type of pie graph that you want to create with your data. For this example, we will choose the simplest of the two-dimensional options. Once you have made this selection, the pie graph will appear in your spreadsheet.
Right-click on the pie graph and another menu will appear. Use the options in this menu to make any modifications that you wish to the format. For our example, we will change the wording in the title and apply labels to the pie graph.
Save your Excel file so that you do not lose your work.
Tips & Warnings
- Don’t forget to save your work after each step. This will eliminate frustration caused by your computer accidentally crashing. It will also allow you a return point if you make any mistakes along the way.