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 . As we know that GOOGLE SHEETS is an emerging analytical tool.
Analysis of data is the process of deriving the inferences by finding out the trends, averages etc. about different parameters.
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 LINE CHART OR LINE GRAPH.
A LINE CHART IS USEFUL WHEN WE HAVE A LARGE NUMBER OF DATA POINTS OR WHEN WE WANT TO CHECK ANY TREND WITH RESPECT TO TIME.
WE CAN ALSO USE LINE GRAPH OR LINE CHART WHEN WE HAVE A BIG NUMBER OF CATEGORIES.
In this article, we’ll take a closer look about the LINE GRAPH or LINE CHART in GOOGLE SHEETS, how to create line chart, purpose of line chart and setting the different properties of line chart in GOOGLE SHEETS.
There is no direct button for the line chart in google sheets but a button for inserting chart is there which will allow us to choose the LINE CHART.
INSERTING CHART USING THE TOOLBAR
We can choose INSERT CHART option from the standard tool bar as shown in the picture below.
DAY | PM 10 | PM2.5 |
1 | 38 | 15 |
2 | 37 | 27 |
3 | 26 | 44 |
4 | 48 | 22 |
5 | 23 | 28 |
6 | 42 | 41 |
7 | 43 | 24 |
8 | 24 | 38 |
9 | 26 | 29 |
10 | 46 | 43 |
11 | 20 | 32 |
At first, we’ll create a line chart for the PM10 data and check its trend over the given 11 days.
So , we have successfully created a LINE CHART in google sheets.
Let us now see the basic customization which we can perform on the chart or graph.
But there are few options which we can insert in the chart to make it better.
After editing the axis titles, chart names etc. , here is our final LINE CHART.
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