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 TIMELINE CHART.
A TIMELINE CHART IN GOOGLE SHEETS PROVIDES THE OPTION OF REPRESENTING THE DATA IN A CHRONOLOGICAL WAY. THE
In TIMELINE CHARTS , one axis shows the date or time and the other shows the values. We also have the option of mentioning the details at every point in the chart.
Although maximum charts can be used at almost any situation even then some charts are meant for very specific use. Such is the case of the TIMELINE CHARTS.
As the name itself show, timeline charts shows the TimeLine of a group of events in a chronological way.
So we can make use of TIMELINE CHARTS in the following situations.
The pie chart can be easily inserted by the chart button on the toolbar itself.
The button location is shown in the picture below.
Some of the specific charts in google sheets , require the data to be laid down in a certain fashion.
Same is the case with the TIMELINE CHART in google sheets.
Let us learn the format of the table in which the data is put.
We can create a TIMELINE CHART with a table containing at most Four Columns.
FIRST COLUMN : DATE / TIME / DATE AND TIME FORMAT ONLY. The first column needs to contain the Date or time format only otherwise TIMELINE CHART won’t respond and no chart will be created.
SECOND COLUMN: DATA / VALUE : The second column needs to contain the values against the date or time of the events.
THIRD COLUMN: HEADING OF THE COMMENTS : We have the option of giving the details about the events. All the details will be present in the chart itself.
FOURTH COLUMN: DETAILS OF THE COMMENTS: The fourth column contains the details of the HEADING given as the COLUMN THREE.
ACCOUNT DETAILS | |||
DATE | AMOUNT | DETAIL HEADING | DETAILS |
1/1/2020 | $156.00 | CREDIT: | CASH DEPOSIT |
4/1/2020 | $234.00 | CREDIT: | DIGITAL DEPOSIT |
3/31/2020 | $435.00 | DEBIT: | WITHDRAWAL |
5/6/2020 | $456.00 | CREDIT: | ONLINE CREDIT |
4/24/2020 | $567.00 | CREDIT: | CREDIT FROM SAM |
6/1/2020 | $124.00 | DEBIT: | WITHDRAWAL |
9/5/2020 | $453.00 | CREDIT: | DEPOSIT |
The procedure to insert a Timeline chart are as follows:
GOOGLE SHEETS provided us with the columns chart.But we need TIMELINES CHART. So follow the steps to convert the chart to the desired 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