PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

CREATE 3D PIE CHART IN GOOGLE SHEETS

INTRODUCTION

CHARTS are the graphic representation of any data . Google Sheets provide us a number of visualization options in the form of different charts and graphs etc.

Excel gives us a variety of charts which are beautiful, colorful, more customizable and more powerful.

In this article we are going to discuss one particular type of the charts which are known as PIE CHART.

3D PIE CHARTS SHOW THE DATA IN THE FORM OF A CIRCLE (PIE) WHERE THE AREA OF EACH SLICE REPRESENTS THE PERCENTAGE OF A PARTICULAR ITEM IN THE WHOLE PROCESS.

In PIE CHARTS, the area shown by a portion shows the percentage or value of particular category.

We’ll discuss in detail, the different processes to create PIE CHARTS.

WHERE IS THE OPTION FOR PIE CHARTS IN GOOGLE SHEETS

The pie chart can be easily inserted by the chart button on the toolbar itself.

The button location is shown in the picture below.

  • Click the CHARTS BUTTON which will open the Chart Editor.
  • In the Charts Editor, Select PIE CHART from the CHART TYPE DROP DOWN as shown in the picture below.
BUTTON LOCATION FOR PIE CHARTS
MENU OPTION TO INSERT PIE CHART:
We can insert a chart using the Menu also as chart option is available in the menu too.
  • Go to INSERT MENU > CHART.
  • After clicking the CHART , CHART option will appear.
  • Choose PIE CHART from the CHART TYPE DROP DOWN.
The location is shown below in the picture.
MENU OPTION LOCATION FOR INSERTING PIE CHART

STEPS TO INSERT A PIE CHART IN GOOGLE SHEETS

EXAMPLE DETAILS

We can demonstrate the chart using an example.
We are taking the example of a class.
The total students are 100 and grades of the students in MATHEMATICS are given below in the table.
TOTAL STUDENTS100
  
GRADESSTUDENTS
A10
B40
C30
D20

The procedure to insert a pie chart are as follows:

STEPS TO INSERT A PIE CHART IN EXCEL:

  • The first requirement of any chart is data .  So create a table containing the data.  [ We have already created in the form of table above]
  • Refer to our data above, we have  grades of 100 students.
  • Select the complete table including the HEADER NAMES.
  • Go to TOOLBAR > CHARTS .
  • At first, Google Sheets will create a chart on its own. [ As per data it would try to suggest us the chart ].
  • The chart will be created and shown to you as the following picture
  • In our example, Google Sheets itself opted for the PIE CHART and created one for us.
 
PIE CHART IN GOOGLE SHEETS

CHANGE ANY CHART INTO PIE CHART

So , we have successfully created a PIE CHART in GOOGLE SHEETS.

 

But , what if the google sheets didn’t create pie charts directly and created some other type for us.

 

In that case, we can simply click the chart, go to CHART TYPE and select PIE CHART.

The result will be same.

 

Let us change the type to COLUMN CHART and then change it to PIE CHART.

We are forcibly converting the PIE CHART to COLUMN CHART so that we become comfortable with the steps to convert it to PIE again if google creates any chart other than PIE in the first place.

COLUMN CHART FOR THE SAME DATA

FOLLOW THE STEPS TO CONVERT COLUMN CHART INTO PIE CHART

  • Click on the chart.
  • Chat Editor will open on the right of the screen.
  • Go to Chart Type.
  • Select PIE CHART from the Drop Down.
Refer to the animated picture below for the procedure.

 

CONVERT COLUMN CHART TO PIE CHART

NOTE:

FOR ALL OTHER TASKS LIKE CHANGING THE NAME OF THE CHART, CHANGING THE AXIS , CHANGING THE CHART STYLE ETC. VISIT HERE [HOW TO CREATE A CHART IN GOOGLE SHEETS ].

 

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

KINDLY SPEND FEW SECONDS HERE....

-We might be compensated for the visits or purchases you make by clicking the ads on this website .  They help us to keep bringing excellent quality articles for you.
-Click on the pictures if you can’t read. All of them are High Resolution .
-If you can’t find what you were looking for, kindly message in the chat box.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW