Home - The Productive Engineer

Pie charts are a popular visual aid for presenting parts of a whole. They help to present data in a clear and easily understandable way. Creating pie charts in Google Sheets is straightforward and can really help make your data more digestible. This tutorial will teach you how to create pie charts in Google Sheets. To create a pie chart in Google Sheets, do the following: Select the data to be used for the pie chartGo to the menu item Insert, and from the drop-down menu, select Chart.Enter the chart data, and your pie chart will be generated automatically. Looking to get more proficient in Google Sheets? Check out our Beginner's Guide to Google Sheets with Screenshots and Video Tutorial. Creating a Pie Chart in Google Sheets Table that we will use to create a pie chart in Google Sheets Before creating your pie chart, a data source is required. This may be school grades or sports results with their frequency. The key is that you need some data from which Google Sheets can generate a pie chart. So let's get started creating a pie chart in Google Sheets! Step by Step Guide to Create a Pie Chart on Google Sheets The following are detailed steps of how to create a pie chart on Google Sheets. Step 1: Select the Data You Want to Use for Your Pie Chart Selecting the cells we want to use for a pie chart in Google Sheets First, you should select the data to be used to generate the pie chart by left-clicking and dragging your mouse across the data you want to use as shown in the screenshot above. Step 2: Go to Insert -> Chart in the Main Menu Insert Chart option in Google Sheets In the main menu, go to Insert -> Chart, you have the option of creating a chart from the selected data. Select a pie chart from "Graph type" in the graph editor displayed on the right side of the spreadsheet. Step 3: Generate a Pie Chart Generating a pie chart in Google Sheets Depending on the context, Google Sheets inserts a different diagram as a suggestion. If the pie chart is not inserted initially, you can use the "Chart Type" option in the "Chart Editor" panel to convert the chart to a pie chart as shown in the screenshot above. Looking to learn how to use conditional formatting in Google Sheets? You have to check out our Ultimate Guide to Conditional Formatting in Google Sheets. Formatting a Pie Chart in Google Sheets Now that you have generated your pie chart, there is a good chance you want to edit it in some way. So let's go over the editing option available in Google Sheets for editing a pie chart. Select Styles/Design Templates Accessing the Theme option in Google Sheets Sheets already has some pretty well-preformatted pie chart design templates. However, these are limited to basic formattings such as colors and text. You can find these templates in the menu item "Format" and the sub-item "Design." Various theme options in Google Sheets As you can see from the screenshot above, Google Sheets provides several options for themes you can use for your spreadsheet and pie chart. Simply click on the theme you want to use and the theme will change accordingly as you can see in the screenshot above. Accessing the Customize chart option in Google Sheets If changes are necessary, you can do this via the "Customize" tab of the "Chart Editor." If you don't select a design template, you can work on changes manually. Format Title Formatting the chart title in Google Sheets Since the title of the pie chart is composed of the column headings by default, you may want to change it. Edited title for pie chart in Google Sheets Double-click on the current title to select it. Press the backspace key to delete it and type in your new title as shown in the screenshot above. Changing the color of a specific pie slice in Google Sheets While Google Sheets come with excellent themes, you may want to change the color of a specific pie "slice". Changing the color of a pie slice in Google Sheets To do this, double-click to select the respective "piece of cake," right-click and select "Format pie slice" from the available options. Then, choose an appropriate fill color. Changed color for a pie slice in google sheets Your pie slice should now be in the color you selected as shown in the screenshot above. This can be repeated for each part of the pie chart as needed. Creating an Inner Circle to a Pie Chart in Google Sheets Accessing the "Donut Hole" option for charts in google sheets You can also make a donut out of the cake by adding an inner circle. To create a donut hole inside your pie chart, do the following: Right-click on your pie chartSelect "Chart Style" from the available options to bring up the Chart Editor panelClick on the "Customize" tabClick on the "Pie Chart" dropdown to open up the pie chart optionsClick on the "Donut Hole" dropdown and select the size percentage you want Setting the donut hole size to 50% in Google Sheets You can format this in 25% steps. You can also choose 50%. The option is in the "Pie chart” subsection of the “Customize” area of the diagram editor as shown in the screenshot above. Customizing Pie Chart Labels in Google Sheets The Slice label setting for a chart in Google Sheets At the same time, you can provide each segment with a segment label. There are "Label," "Value," "Percent," and "Value and Percentage." Value and Percentage setting for pie chart in Google Sheets By choosing the latter, you will see the absolute and relative frequencies in each segment as shown in the screenshot above. Setting the font to white and 12pt for pie slices in Google Sheets In addition, you can set the font color to white and reduce the font size a little if only partial segments are provided with frequencies. Changing the Distance to the Center ("Circle Explosion") Distance from center setting for a pie slice in Google Sheets To emphasize a pie slice by offsetting it from the center of the circle in Google Sheets, do the following: Double-click on the pie slice you want to emphasize to bring up the Chart Editor for that sliceClick on the "Customize" tabClick on the "Pie slice" dropdownClick on the "Distance from center" dropdown and select the offset percentage Pie slice offset from center in Google Sheets You should see your pie slice offset as shown in the screenshot above. Downloading a Created Pie Chart Downloading a pie chart in google sheets You can download your pie chart as an image file or PDF. To download your pie chart in Google Sheets, do the following: Click on the pie chartClick on the vertical ellipsis button in the upper-right corner of the pie chartSelect "Download" from the optionSelect the file type you want from the available options Publishing a Pie Chart Publishing a pie chart in Google Sheets To publish your pie chart to the web in Google Sheets, do the following: Click on the pie chartClick on the vertical ellipsis button in the upper-right hand corner of the pie chart windowSelect "Publish chart" from the available optionsClick on either the "Link" or "Embed" tab based on your needsClick the "Publish" button Publishing options for a pie chart in Google Sheets the link to a published pie chart in Google Sheets Your pie chart should now be published and accessible either via URL if you chose the "Link" option or as an embeddable code for your website via the "Embed" option I hope this tutorial was helpful to you. Good luck!

How to be Productive When Working Remote

Recent Posts