Extra: How to Find Duplicates in Excel Data and Remove Them # You can repeat the process for each slice in your pie or leave it as-is if you want to highlight a particular result. We even have a dedicated bar graph in Excel guide to help you make one. If you realized that a pie chart doesn’t really work with your data set, chances are you can’t go wrong with a trusty bar graph. How to Make a Quick Pie Chart in Excel # How to Label a Pie Chart in Excel # How to Customize a Pie Chart in Excel # How to Explode a Pie Chart in Excel # How to Create a Pie of Pie Chart # How to Create a Bar of Pie Chart # Extra: How to Make a Bar Graph in Excel # If your data set doesn’t fit those requirements, you may be better served by our bar chart tutorial, which is linked at the bottom of the page. We’ll first look at creating a basic Excel pie chart, then move on to adding labels, customizing its visuals, exploding the pie chart, and finally creating a pie chart with a bar chart to the side.īefore you put the time in to make a pie chart in Excel, do bear in mind that you can only display a single data series in one and are unable to use zero or negative values. How to make a pie chart in Excel: There are different ways Our task is to visualize the proportional distribution of the males and females in the list.1 How to Make a Quick Pie Chart in Excel2 How to Label a Pie Chart in Excel3 How to Customize a Pie Chart in Excel4 How to Explode a Pie Chart in Excel5 How to Create a Pie of Pie Chart6 How to Create a Bar of Pie Chart7 Extra: How to Make a Bar Graph in Excel8 Extra: How to Find Duplicates in Excel Data and Remove Them 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.

How to create pie chart in excel on m