How to make a pie chart in Google sheets

Making a pie chart in Google sheets
Tutorial
May 19 2020

Pie charts are an essential tool in any charting toolkit. Pie charts are great for visualising percentages and proportional data. In this tutorial we will be creating a pie chart to represent monthly financial outgoings. We will see how the pie segments are labelled, and how the colours can be customised. 

Related tutorials

Step 1: Setup your sample data

Add your data

In a blank Google sheet, setup your data. In the cell A1, enter the name of your category, eg 'Type of expenditure', in B2, enter 'Amount'. Then fill in the different types of expenditure you would like to visualise under the heading in column A. Add the corresponding amount spent in column B.

Alternatively, you can open the starting spreadsheet which contains pre-populated sample data.

Step 2: Insert a new pie chart

Insert a pie chart

Draw a selection box around your data from the top of column A, to where your data ends in column B. Then goto Insert > Chart.

Step 3: Customise the color of a pie segment

Setting the color of a pie segment

In the chart editor, select the Customise tab. Then open the Pie slice section. Choose which item you want to change, and choose a color from the Color selector.

Note: If the Chart editor is not already open, double-click the chart to open it.

Step 4: Setting the pie chart to 3D

Setting the pie chart to display in 3D

If you want to make your pie chart display in 3D format, open the Chart editor. Then click on the Customize tab. Next, open the Chart type section, and check the 3D option. 

Note: If the Chart editor is not already open, double-click the chart to open it.

Step 5: Displaying the pie chart legend as a key

Setting the pie chart legend to a key

The default legend option is the call out label. To display the legend as a key, go to the Customize tab in the Chart editor. Open the Legend section and choose Bottom from the Position field. 

Note: If the Chart editor is not already open, double-click the chart to open it.

Spread the word