how do you make a pie chart in excel 2013

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. Next time we’ll look at several other Excel charts included in Excel 2013.Sometimes, you need to make a pie chart in Excel. Also watch for how column and bar charts can overcome weaknesses inherent in pie charts. Watch for some Excel features and tricks that can overcome some of these weakness to some extent. Due to the circular nature of the pie chart and the geometry of circles, it’s often hard to determine if a pie slice is twice as big as another slice or just two-thirds as big as another pie slice, for example.

The third challenge with pie charts is determining the relative sizes of pie slices. Readers can usually determine which slice is the biggest, but it can be harder to decide the order of other pie slices. The second challenge is that it’s hard to tell the relative order of the pie slices. The first challenge with a pie chart is that it takes up a lot of space relative to the amount of data the chart conveys. Excel 2013 Pie Charts are very common, but have three weaknesses we’ll explore and work around in Excel Video 462.

How do you make a pie chart in excel 2013