Forgot your password?

How to Make a Pie Chart with Microsoft Excel

By Edited Jul 8, 2014 0 0

Would you like to know how to make a pie chart with Microsoft Excel? Pie charts are useful when you need to visualize percentages. Microsoft Excel has the capability of automatically creating a pie chart with proportionately sized "slices" for your data. As long as you have more than one related category, and a numeric amount to go with it, converting this to a pie chart will be as simple as clicking a few buttons. So if you'd like to know how to make a pie chart with Microsoft Excel, read on.

How to Make a Pie Chart with Microsoft Excel(52677)
Open Microsoft Excel and enter the categories that you wish to use as you learn how to make a pie chart. In the example, these relate to monthly expenses. Normally in graphing software you will enter data starting from the top, and working your way down. Type each category into a separate cell in the first column, as shown. The graphing software allows you to give the list of categories a title, such as "expenses."
How to Make a Pie Chart with Microsoft Excel(52678)
Enter the data for each category. In the example, there are dollar amounts for each category. So type each number in the column to the right so it aligns with its corresponding category. You can give the column a name here in your spreadsheet as well, such as "amounts."
How to Make a Pie Chart with Microsoft Excel(52679)
Click the bar graph icon in the toolbar of the graphing software (don't worry, you will be changing it to a pie chart in step 4.) By default this button is located at the top left side of the toolbar. It is under the "format" and "tools" icons at the top of the spreadsheet window.

How to Make a Pie Chart with Microsoft Excel(52680)
Notice a dialogue window pops up. On the left side there are icons that depict each type of graph you can select. Click on "pie" and you'll see a preview window appear of different types of pie graphs. Some of the types offered by Microsoft Excel graphing software include 2 dimensional pie charts, 3 dimensional pie charts, and other have "breakout" sections for your circle graph. Either leave the default or select one of the other chart sub-types you like.

Click next twice to advance to step 3. At this point if you would like to change the chart title, type it in the box. As a default you might want to leave it as the column heading for the data you entered, or name it something more descriptive, such as "Average monthly expenses."

How to Make a Pie Chart with Microsoft Excel
Click next again, then save the file where you like. If you select "as a new sheet," it will do so in this same file where you entered the data, but in a different "page." (Pages for this graphing software are found at the tabs at the bottom of the spreadsheet window). If you would like the chart to appear beside the data, select "as an object in," and then click finish. Your pie chart will appear in the area you have selected. You can resize it by clicking and dragging the corners. And that's how to make a pie chart in Microsoft Excel! Good luck!


Add a new comment - No HTML
You must be logged in and verified to post a comment. Please log in or sign up to comment.

Explore InfoBarrel

Auto Business & Money Entertainment Environment Health History Home & Garden InfoBarrel University Lifestyle Sports Technology Travel & Places
© Copyright 2008 - 2016 by Hinzie Media Inc. Terms of Service Privacy Policy XML Sitemap

Follow IB Technology