How To Make A Pie Chart In Google Sheets

Use the chart editor tool or the Explore feature in Google Sheets to create a pie chart using your data.

Pie charts are a simple yet powerful visualization tool that can help you present and analyze data in an engaging and easy-to-understand manner. If you are using Google Sheets as your preferred spreadsheet software, you’ll be glad to know that creating a pie chart is a breeze. In this blog post, we will walk you through the step-by-step process of making a pie chart in Google Sheets, allowing you to effectively communicate your data and make informed decisions based on the insights gained from your visuals. So, let’s dive in and explore how to create stunning pie charts in Google Sheets!

How To Make A Pie Chart In Google Sheets: Step-by-Step


Step 1: Open Google Sheets,

To access Google Sheets, enter “Google Sheets” in your web browser’s address bar and click on the top search result. Then, choose to either open an existing document or start a new one to begin working in Google Sheets.

Next Step

Step 2: Input Your Data,

To create a pie chart, organize your data in two columns – one for the names of each slice and the other for their corresponding values. This way, you can easily input the data and visually represent it in a pie chart format.

Next Step

Step 3: Select the data,

Click and drag your mouse cursor over all of the cells that contain the relevant data you wish to include in your chart, highlighting them for easy selection and insertion.

Next Step

Step 4: Insert a chart,

To insert a chart in your document, simply go to the “Insert” tab on the menu bar and click on “Chart”. This will bring up a default chart along with the chart editor toolbar on the right side of your screen.

Next Step

Step 5: Change the chart type to Pie chart,

In the Chart Editor on the right side of the screen, click the drop down under “Chart type”, and select “Pie Chart” from the list of various chart forms that pops up.

Next Step

Step 6: Customize your chart,

Additionally, you have the flexibility to personalize the chart according to your specific preferences or requirements using the extensive options available in the user-friendly chart editing interface. Modify various aspects such as the color scheme, chart title, legend, and more to create a customized visualization that perfectly suits your needs.

Next Step

Step 7: Place your chart,

Once you have finalized your preferences, simply click on “Insert” and the pie chart will be instantly added to your sheet. It offers flexible manipulation options like movement and resizing for seamless integration with your document’s structure.

Next Step

Step 8: Save Your Work,

In Google Sheets, your work automatically saves, but you can manually save by clicking File, then selecting ‘Save’. Your pie chart is now complete.


In conclusion, learning how to make a pie chart in Google Sheets can be a useful skill for any business or individual. Pie charts are an effective way to visually represent data and communicate key insights with clarity. With the step-by-step guide provided in this blog post, you now have the knowledge to create and customize your own pie charts in Google Sheets. Whether you need to present sales figures, analyze survey responses, or explore any other data set, pie charts in Google Sheets can help you easily grasp and convey the information. So start practicing and incorporating pie charts in your data visualizations to make your reports, presentations, and analyses more engaging and accessible to your audience.

Table of Contents