what do oyu need to make a pie chart in excel

The new chart is selected, so you can move it to a different location, if you don’t want it in the middle of the sheet. The chart will show the heading from the number column as a chart title, and a legend with the text descriptions, if your data includes those. Do not be lured by any of the other options, like exploded pie, or worst of all, a 3-D pie.Ī pie chart will be inserted on the active sheet, in the middle of the Excel window.

Then, click the first pie option, at the top left.

On the Excel Ribbon, click the Insert tab.

Insert the ChartĪfter your data is set up, follow these steps to insert a pie chart: We could create a pie chart from either set of numbers.

In rows 9 and 10, the data is arranged horizontally, with numbers in a single row.

At the top, the data is arranged vertically, with numbers in a single column.

In the screen shot below, you can see two sets of data showing sales per region. I’d pick 6 as the upper limit, but let your conscience (or your boss) be your guide. Warning – Only use a few numbers, or the pie chart won’t be readable.

(optional) heading cells for the numbers and text.(optional) one row or column with text that describes the numbers.What should your data look like, if you want to build a pie chart? It should have the following: The written steps are below the video.īonus: There’s another video at the end of the post, that shows how to add a picture in a pie chart slice Watch this video to see the steps to build a pie chart in Excel. So, if you’ve never built a pie chart in Excel, or it’s been so long that you’ve forgotten the steps, here’s how you can do the best job possible. Your sister needs help with a report for her dessert of the month club, and a pie chart seems okay for that!.Perhaps your professor is basing 50% of your final grade on building the perfect pie chart.Maybe your boss is demanding that you make one for the annual report.Why would you want to make a pie chart? It could be one of these reasons: No, it might not be the best way to present your data, but sometimes you have to go with the chart type that someone else chooses. Our task is to visualize the proportional distribution of the males and females in the list.Sometimes, you need to make a pie chart in Excel. This is a two-column table that contains the names and genders of ten imaginary people.

To show you the ropes, we need to start with some initial data.

Here’s a quick list of where male/female pie charts may come in handy: The goal of such charts is not to make accurate or precise comparisons but to help the audience understand how constituent parts of the chart contribute to the overall picture. Explode a Single Slice (Optional)Ī male/female pie chart depicts a part-to-whole relationship between (surprisingly!) men and women by dividing a circle into proportional segments.

What do oyu need to make a pie chart in excel