Friends, you might have come across a situation where you need to represent data in the form of a Pie Chart. So, you might be wondering how to make a Pie Chart in Google Sheets and what is the need for making a Pie Chart in Google Sheets?
Well! There are various useful reasons to make a Pie Chart in Google Sheets. It is used to show relationships between certain pieces of data and is a very impressive way of conveying an idea in very few words.
Many people do not prefer to use Pie Charts while creating dashboards & reports, however, Pie Charts are widely used and are accepted as a good way of data visualization.
Also, Pie Charts are super helpful tools in the business place and for personal use. Now, you might be wondering how to make a Pie Chart in Google Sheets?
Let’s have a look at how to make a Pie Chart in Google Sheets.
How To Make A Pie Chart In Google Sheets?
Here we are going to look at a step-by-step guide for how to make a Pie Chart in Google Sheets.
After that, we will have a look at some extra steps which you can take and different cool customization that can be done.
Always keep in mind that a Pie Chart is used to do comparisons within the same larger categories.
Let’s take an example where we are going to compare the costs of various financial parameters of studying in a college.
Now, let’s make a Pie Chart to represent the same data.
- First, open the Google Sheets which have the same data.
- Now, select the cells for which you want to create a Pie Chart.
- In the top bar, click on the insert option.
- Now click on the chart option.
Note – Always check that you do not have selected an empty cell, as it will unselect the data for which you want to make a chart.
After following the above steps, Google Sheets will use some assumptions and will guess what kind of chart you want to insert.
Here, we got lucky as Google Sheets already knew that we wanted to make a Pie Chart. You must have noticed that our data is still selected and we can see a Pie Chart next to the data.
Here, we can see that every category is having different colour and a leader is pointing to them via a label, also the cart is titled Cost.
But what will happen if your Google Sheets do not guess the correct chart type or how you can change the chart type?
Here are a few options for you
Left-click on your current chart. It will highlight the entire chart in blue and three dots will be visible in the upper right corner. You will get options when clicking on three dots.
Here you can see the edit chart option. Clicking on this option will open the editor pane on the right-hand side of Google Sheet.
If you have not got the Pie Chart by default, you can change the chart type by clicking, chart type option under the setup tab. If you scroll down, you will get options like Pie, Bar, Column, Area and Line which will help in converting the Pie Chart if it is not already.
Once you have got the default pie graph, you can easily customize and edit as per your needs.
Video Source – Youtube
How To Edit Pie Chart?
What you can do if the automatically generated Pie Chart is not what exactly you are looking for?
The good news is you can easily edit & customize lots of options in your chart.
Here is what you can do.
First, we need to click on the edit chart by following the same procedure as mentioned above.
Now, the chart editor will open and will display some options as below.
Change The Data Range In A Pie Chart
If you have messed up during your first attempt at making a Pie Chart and have picked up the wrong cells then do not worry and you can fix this issue with the help of the ‘Data Range’ option available under chart editor.
From here you can choose a new range by manually typing data range in the box or you can left-click & highlight the cells in the workbook.
As soon as your date range will change, it will automatically change your Pie Chart.
How To Change The Label In Your Pie Chart?
If you want to change the label in your Pie Chart, that can be done easily.
Here in our example, there is no need to change the label as there are only two columns where one of the columns has price values which are plotted as pie slices.
However, if you wish to change the labels, then you can do it from here.
How To Customize The Aesthetics Of Your Pie Chart?
The final customization you should look at is the ability to customize the aesthetics of your Pie Chart.
So, what does it mean?
With this, you can change the colour of your Pie Chart, add a legend, change tiles & labels and make it 3D. you can also add a doughnut hole.
To do this click on the customize option under your chart editor.
Now, let’s see how to do it.
Changing Chart Style Of Pie Chart
When you click on the chart style option you will get various options to do changes.
Following things can be changed in the chart using these options
- Font style of your text.
- The background colour of your Pie Chart.
- Border colour of the Pie Chart. However, if you don’t need the border colour of the Pie Chart then you can see border colour to none.
You can also convert a normal chart into a 3-D chart. However, I will not recommend it as it is hard to read and often misleading
How To Customize The Pie Chart Option?
Now we have to customize the menu in Pie Chart. So, when you will click it, it will give you a drop-down list of options.
Again, you will get some interesting options to customize.
- You can add a label to each slice of the Pie Chart.
- Change the border colour of each slice with the help of the border colour option.
- Doughnut hole- With the help of this option, you can easily convert your Pie Chart into a doughnut chart. You just need to specify the value of the doughnut hole and Google Sheets will automatically add a hole with the specified space.
How To Change Pie Slice Of Pie Chart?
With the help of this option, you can make one slice stand out by making it slightly protrude outside the Pie Chart.
This will look like below where I have made the rent slice a bit prominent as compared to other slices in Pie Chart.
To do this you can follow the below steps.
- First click on the customize tab under the chart editor.
- Now click on the Pie slice option. Here you will get lots of options to explore.
- Click on the drop-down and choose the category which you want to highlight.
- You can also change the colour of the Pie Chart (this is optional).
- You can also choose the distance from the centre option to the prominent one of the slices.
With this article, you must have got an idea that how to make a Pie Chart in Google Sheets. You can create a Pie Chart with the help of a few clicks only.
Also, with the help of the customization option, you can explore interesting options which we have covered in the article.
Always keep in mind, when it comes to displaying data in Google Sheets, the Pie Chart is the best option, and with the help of our guide, you know how to make a Pie Chart in Google Sheets.