PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
CHARTS are the graphic representation of any data .
Analysis of data is the process of deriving the inferences by finding out the trends,totals, subtotals other operations etc. about different parameters.
Data is everywhere. There is no work, where we don’t deal with the data.
Sales data in business, employee data, patient data in hospitals, students data in school etc. Maximum data is presented in the tables but we all know that visual representation is easier to interpret.
GOOGLE SHEETS gives us a variety of charts which are beautiful, colorful, more customizable and more powerful.
In this article we would learn –
INSERTING CHART USING THE TOOLBAR
We can choose INSERT CHART option from the standard tool bar as shown in the picture below.
INSERTING CHART THROUGH MENU:
We can insert Chart through the menu options too.
Go to INSERT MENU> CHART as shown in the picture below .
There are many benefits of charts or graphs such as:
A chart is always made from the data in the tabular form. So before making a chart , we need the data in the tabular form.
Suppose we have the marks of the students as given in the table.
Before the steps, let us check the available data.
The data is simple and short. It comprises of marks of 5 students. Lets try to make different charts for this data.[DATA CAN BE COPIED EASILY FOR PRACTICE]
STUDENTS | MARKS |
ASHU | 34 |
SWATI | 45 |
RAVI | 65 |
JOHN | 33 |
MARY | 32 |
The axis in the chart can be changed in the following ways. We also know this feature as Switching row to column and vice versa.
There are two axis in the 2d charts or graphs. One is the X AXIS or the HORIZONTAL AXIS and the other is Y AXIS or VERTICAL AXIS.
The data is plotted against the horizontal and vertical axis both. A need can arise when we want to change the axis, which means, to put the data on the horizontal axis on the vertical and vice versa.
Follow the steps to change the axis in the chart.
GOOGLE SHEETS offers a variety of chart types. e.g. column type, line type, pie type and many more shown in the pic. We can easily change the chart type by easily clicking on the type as per our need.
The need of chart depends upon the type of data to be presented.
There is no need to do anything to the data. Lets try to change the chart type of the above mentioned data.
STEPS TO CHANGE THE CHART TYPE IN GOOGLE SHEETS:
Look at the picture below .
LAYOUT is the way in which the information is presented. Suppose we have a pie chart (The circular chart in which the portions are fixed as per percentages.)
Now there can be different layouts for a pie chart. e.g.
The written information can be far away or written with the portions, written on the portion etc. Color Scheme can be chosen and many more.For changing the layout of the chart do the following steps.
There are no ready made options for the layouts but we can create them by choosing the different options and locations of captions, information etc.
In a standard chart there are many captions[labels]. For example, the chart name, horizontal axis names, vertical axis names, etc.
Google Sheets picks up these names from the Headers of the data table.
If the auto names given for the chart doesn’t fulfill your desired presentation , you can always insert or edit any captions of the axis or any details in the chart. Lets give some random names to the chart details. We can also insert new captions or text anywhere on the chart.
In this section, we would learn to change the chart name, axis names of the charts or graphs made in google sheets.
STEPS TO EDIT CAPTIONS:
1.Double click any text [CHART NAME or AXIS NAME, which you want to change ]. The text will go to the edit mode and cursor will start blinking. Just make the changes and click ENTER.
2.Click ENTER and the new caption will be finalized.
We can do the same using the CHART EDITOR OPTIONS too.
The following picture shows the process.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE