How To Do A Pie Chart In Google Sheets

Visual data representation is an effective way to understand complex data. Pie charts are one of the simplest and most commonly used graphical formats for displaying data. This blog post will guide you on how to create a pie chart in Google Sheets step by step.

Step 1: Prepare Your Data

To start with, you need some data. Any kind of data that can be broken down into categories can be used to create a pie chart. Your data should be arranged in columns or rows on a single sheet, and you need at least two columns or rows of data to draw a pie chart. For example:

Category Amount
Food $200
Rent $800
Utilities $150

Step 2: Select Your Data

The next step is to select the data you want to include in your chart. To do this, simply click and drag your mouse to highlight the cells that contain the data you want to use.

Step 3: Insert a Chart

Once your data is selected, click on the “Insert” menu at the top of the screen. In the drop-down menu that appears, click on “Chart”.

Step 4: Choose Pie Chart

In the chart editor on the right, click on the “Chart type” drop-down and select “Pie”. You can choose a 2-D or 3-D style, depending on your preference.

Step 5: Customize Your Chart

Finally, you can customize your pie chart by changing the colors, adding labels, and more. To do this, click on the “Customize” tab in the chart editor.

Code Snippet to Generate a Pie Chart

If you want to generate a pie chart using code, here is a simple code snippet.

function drawChart() {
 var data = new google.visualization.arrayToDataTable('MyData');
 var options = {
     title: 'My Expenses',
     pieHole: 0.4,
 var chart = new google.visualization.PieChart(document.getElementById('donutchart'));
 chart.draw(data, options);


Creating a pie chart in Google Sheets is simple and straightforward. It’s a quick and efficient way to visualize your data. Just follow the steps above, and you’ll have a beautiful pie chart in no time.