Blog of Calc LLC

This tutorial teaches you how to make pie chart in Google Sheets. In Google Sheets, donut chart is regarded as a special type of pie chart (pie with a hole). So, this tutorial is also on how to make a donut chart. Suppose you run a grocery store and record the sales of items. The data is below: 1. Select the data. 2. On the menu, click Insert > Chart . A pie chart pops up automatically. Unlike Excel, Google Sheets are "smart". It tries to understand your data and select the most appropriate type of charts according to its understanding. 3. The percentages of sale volume for each item is already shown. Suppose we want it to display the dollar value as well. Right click the chart, then click Chart style . 4. Under Pie chart , we change Donut hole to 50%, and under Slice label , select value .  5. Now you get a pretty donut chart. If you set the donut hole to 0% in the last step, you will get a solid pie chart instead.

Pie chart is used when all the values is a component of a total and they are all positive. Suppose we have data below indicating sales of amount for each product in a grocery store. 1. Click Insert > Charts > Pie > 2-D Pie 2. You get a pie chart like this. From this table, we can which products sell better than others. 3. If you want to, you can add data labels. Click the chart, then click Chart on the menu, Click Data Labels, then select Best Fit. 4. Now the sales amount is displayed on the chart.