Google Sheets is a great tool to work on spreadsheet files online. You can use it no matter the operating system you use. Just like similar tools like Microsoft Excel or LibreOffice Calc, Google Sheets also comes with features to make it easy for you to analyze data. One of which, Google Sheets allows you to create a pie chart from a table consisting of numbers. We will show you how to create a pie chart in Google Sheets.
The pie chart itself is just one of the chart types you can create in Google Sheets. You can also create other chart types such as bar chart, line chart and so on. Adding a pie chart on a spreadsheet file is helpful enough especially if you are working on a report file. Not only it makes it easier to analyze the data, but it can also be a good assistant if you have to make a presentation of the report.
We will create a pie chart from a simple data of the sales report of a camera store like the following.
To create a pie chart from the data above, you can highlight the data range you want to create the chart of.
Once the data is highlighted, click the Insert menu and select Chart. The highlighted data range will immediately turn into a chart. By default, Google Sheets creates a pie chart with the following look.
How to customize the pie chart
A new panel will appear on the right side of the Google Sheets screen once you select Chart from the Insert menu. You can customize your chart via this panel. If you don’t see this panel, you can double-click your chart to turn it into an editing mode. On the Setup tab on this panel, you can change the chart type on the Chart type section.
If you want to extend the data range, you can click the table icon on the Data range section.
Please note that Google Sheets will make the first row of the selected data range as the header and this row will not be included on the chart. If you want to include the first row to the chart, you can uncheck the Use row n as headers.
- Change the chart style
By default, Google Sheets creates a pie chart in a 2D format. In case you want to turn it into a 3D format, you can go to the Customize tab on the right panel and open the Chart style section. Simply click the 3D option to enable the 3D effect. You can also set the background color of the chart, the border color as well as the font.
- Customize the label
Google Sheets allows you to set what you want to display on each slice (dataset) of the chart. Whether the label, the value, the percentage or the value and percentage. To do so, you can open the Pie chart section on the right panel. You can set what you want to display on each slice from the Slice label option.
From this section, you can also set the font of the slices (as well as the size), the donut hole level, and the border color (border color only works on 2D chart).
- Set the color of each slice
Google Sheets allows you to set the color of each slice. To do so, you can open the Pie Slices section on the right panel. Select a slice from the dropdown menu and set the color via the color selector beneath it.
- Set the chart title
To set the title of your chart, you can open the Chart title section on the right panel. Simply enter your preferred title on the Title text field. If you want, you can also add a subtitle for your chart. From this section, you can also set the title font, title font size and the title font color.
- Set the legend position
Legend is a crucial enough element of a pie chart. It adds additional information about your chart. The readers of your chart will instantly know what color represents what from the legend.
By default, your pie chart has a labeled legend. You can change it — as well as the position — via the Legend section on the right panel. Simply select the legend position from the dropdown menu.
As you can see, there are also options to set the legend font, the legend font size as well as the legend font color.
Once done customizing the chart, you can set its position on the worksheet by dragging it to any place you want. You can also set its size by pointing your mouse to the corner of the chart. Click and hold and drag your mouse to resize it.