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 . Google Sheets provide us a number of visualization options in the form of different charts and graphs etc.
GOOGLE SHEETS 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 RADAR CHART.
A RADAR CHART IS A SPECIAL TYPE OF CHART IN THE SHAPE OF A STAR WITH DIFFERENT VARIABLES OR PARAMETERS REPRESENTED ON THE AXES ARISING FROM THE SAME CENTER AND VALUES ARE PUT ON THE AXES.
In RADAR CHARTS, the values are shown on different axes.
We’ll discuss in detail, the information about the RADAR CHART and the way to create one in google sheets.
A RADAR CHART is a chart in the form of a star or a polygon with different parameters plotted on the axes which arise from a center and the values are shown on the axes. The values are then joined to the adjacent axes with the simple lines.
A sample RADAR CHART is shown below.
[LOOK AT THE PICTURE ABOVE]
A RADAR CHART has the different axes arising from a single point as it is clear in the chart above, all the axes are arising from 0.
The variable which are the height, weight and chest are marked for each and every student on respective axes.
After marking, all the values are joined together to form a polygon.
The radar chart is known by many other names such as
STAR CHART, STAR PLOT, COBWEB CHART, POLYGON CHART, POLAR CHART AND KIVIAT DIAGRAM ETC.
In the next section, we take a look upon the different apt situations where we can make use of RADAR CHARTS.
One star represent the variation among different series.
A RADAR CHARTS should be used when
The RADAR CHART can be inserted through the INSERT MENU > CHART and choosing RADAR chart or by directly choosing the CHART BUTTON on the toolbar and then choosing the RADAR chart.
RADAR CHART BUTTON ON TOOLBAR
It is always easy to create a chart if we lay the data properly.
Similarly, for the RADAR CHARTS it is important to know the layout of the data for the perfect chart , as we require.
The FIRST COLUMN can be used to provide the LABELS.
The FIRST ROW will contain the CATEGORIES.
OTHER COLUMNS can be used to enter values.
A sample of the table and the radar chart for the table are shown below.
STUDENT | HEIGHT | WEIGHT | CHEST |
STUDENT 1 | 123 | 56 | 34 |
STUDENT 2 | 142 | 58 | 35 |
STUDENT 3 | 112 | 55 | 36 |
STUDENT 4 | 132 | 33 | 23 |
STUDENT 5 | 231 | 100 | 65 |
The RADAR CHART for the data is shown below. The steps to create the chart are discussed in the next section.
The radar chart is known by many other names such as
STAR CHART, STAR PLOT, COBWEB CHART, POLYGON CHART, POLAR CHART AND KIVIAT DIAGRAM ETC.
In the next section, we take a look upon the different apt situations where we can make use of RADAR CHARTS.
STUDENT | HEIGHT | WEIGHT | CHEST |
STUDENT 1 | 123 | 56 | 34 |
STUDENT 2 | 142 | 58 | 35 |
STUDENT 3 | 112 | 55 | 36 |
STUDENT 4 | 132 | 33 | 23 |
STUDENT 5 | 231 | 100 | 65 |
The procedure to insert a RADAR chart are as follows:
GOOGLE SHEETS itself created a column chart for us, but we need to create a RADAR CHART.
So follow the process to create the radar chart from the create column chart.
Click the RADAR CHARTS option and the chart will be converted to a RADAR CHART.
The following picture shows the RADAR CHART created. [Except the
The RADAR CHART created by the google sheets by default has the smooth (curved) lines joining the axes.
We can make them straight if we want.
The following picture shows the CURVED CONNECTING LINES and STRAIGHT CONNECTING LINES.
You can see that the ONLY DIFFERENCE is VISUAL and it is up to the user only which one to choose.
FOLLOW THE STEPS TO CHOOSE SMOOTH OR STRAIGHT CONNECTING LINES IN A RADAR CHART
Double Click the chart to open the chart editor. [ If the chart editor is not open]
Go to Chart Editor.
Click on CUSTOMIZE TAB.
Open the CHART STYLE drop down.
In the lower portion, CLICK ON THE SMOOTH CHECKBOX to smooth the connecting lines.
If you want straight lines, uncheck the SMOOTH CHECKBOX.
The process is shown below in the picture.
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
YOU MAY LIKE