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.
Excel gives us a variety of charts which are beautiful, colorful, more customizable and more powerful.
In this article we are going to discuss ORG OR ORGANISATIONAL CHARTS IN GOOGLE SHEETS.
ORG OR ORGANISATIONAL CHARTS ARE USED TO REPRESENT THE HIERARCHY OR RELATIONSHIP BETWEEN EMPLOYEES, COLLEAGUES, FAMILY ETC.
In ORGANISATIONAL CHARTS the higher place represents HIGHER POSITION in HIERARCHY. For example, in a family, father would come at the top, followed by children and then grand children and so on.
Let us discuss purpose, syntax formula and examples of using org chart in google sheets.
ORGANIZATIONAL CHARTS are the solution to the following situations.
If you want to –
The pie chart can be easily inserted by the chart button on the toolbar itself.
The button location is shown in the picture below.
CHILDREN | PARENT | COMMENTS |
FATHER 1 | GRAND FATHER | COMMENT1 |
FATHER 2 | GRAND FATHER | COMMENT2 |
CHILD 1 | FATHER 1 | COMMENT3 |
CHILD 2 | FATHER 1 | COMMENT4 |
CHILD 3 | FATHER 2 | COMMENT5 |
CHILD 4 | FATHER 2 | COMMENT6 |
The procedure to insert a organizational chart are as follows:
After making a few tweaks , our final organizational chart looks like the following one.
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