If you noticed that you’ve entered the same data multiple times after creating your pie chart (a common mistake) you can try some of the formulas in our how to find duplicates in Excel guide. We even have a dedicated bar graph in Excel guide to help you make one.Įxtra: How to Find Duplicates in Excel Data and Remove Them 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.

The smallest sections of your pie will be automatically split into a bar chart.

The option is in 2-D pie settings, next to the pie in pie icon.

Select your data, click the pie icon, and choose the Bar of Pie chart option.

This is quite useful, as it lets viewers more easily see the differences between them: How to Make a Quick Pie Chart in ExcelĪlternatively, you can create a Bar of Pie chart, which as you may expect displays a small bar chart next to your data for the smallest.

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 In this article we’re going to show you how to create a pie chart in Excel with labels so that you can have the best of both worlds. However, though great, they aren’t exactly precise – it’s hard to discern an accurate number from the angle of a particular section. Pie charts are an incredibly useful tool when you want to highlight the differences between certain data points. 8 Extra: How to Find Duplicates in Excel Data and Remove Them.7 Extra: How to Make a Bar Graph in Excel.

3 How to Customize a Pie Chart in Excel.1 How to Make a Quick Pie Chart in Excel.

Create pie chart in excel from data