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.
|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 we choose the ORGANIZATIONAL CHART, as shown in the picture above, a chart will appear as shown in the picture below.
After making a few tweaks , our final organizational chart looks like the following one.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE