Sunday, October 20, 2013

How to Make Pie Graphs in Excel


1.
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.
2.
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.
3.
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.
4.
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.
5.
Save your Excel file so that you do not lose your work.

Blogger news