Unlike in cake charts or line graph, you can only display a single data series in a pie chart, and you can ’ metric ton use zero or negative values when. Remember, pie charts can only handle one measurement or value per independent variable. First, Highlight The Data You Want In The Chart:Īt the end, i also show you how. First, we select the data we want to graph. Click insert tab, pie button then choose from the selection of pie chart types: Source: Pie, exploded pie, pie of pie, bar of pie, or 3d pie chart. Source: Ĭlick the paintbrush icon again to close styling options. Learn how to create and style a pie chart in excel. Source: This will add all the values we are showing on the slices of the pie.

This should include what is being measured, and how much of it there is. Then click the insert tab, and click the dropdown menu next to the image of a pie chart. Source: Unlike in cake charts or line graph, you can only display a single data series in a pie chart, and you can ’ metric ton use zero or negative values when. From your excel worksheet, highlight the data you want to appear in your pie. Source: Select the data, click insert, click charts and then choose the chart style you want. Just like any chart, we can easily create a pie chart in excel version 2013, 2010 or lower. Excel pie chart How to combine smaller values in a single from Ĭlick insert > chart > pie, and then pick the pie chart you want to add to your slide.

How to create pie chart in excel 2013