Create an Organisational Chart in Google Sheets
ฝัง
- เผยแพร่เมื่อ 5 มิ.ย. 2023
- This tutorial covers how to create an organisational chart in Google Sheets.
We will cover how:
1. How to set up your data for the chart.
2. Plan your organizational chart layout (Added the 'z' for my U.S. friends 😉)
3. Buld the Chart.
4. Create a hover effect to display a tooltip or a name.
5. Style the chart.
6. Embedding the chart in a HTML file or, say a Google Slide.
7. Some limitations of the Google Sheets Organisational Chart.
To the Starter Sheet:
docs.google.com/spreadsheets/...
** USEFUL LINKS **
- The original Orville Chain of Command image: i.redd.it/apmr1lusfzc41.png
- Organisational Charts Docs: support.google.com/docs/answe...
** My Site **
yagisanatode.com/
** More on Google Sheets **
yagisanatode.com/google-sheets/
** The Named Functions Pack **
yagisanatode.com/products/nam...
* Courses *
yagisanatode.com/products-cat...
* Google Workspace Tools *
yagisanatode.com/products-cat...
* Google Workspace Add-ons *
yagisanatode.com/products-cat...
#GoogleSheets #googleworkspace #spreadsheets #businessadministration #admin #businessmanagement
That was amazing. I had no idea as to how many commands could be written into a spreadsheet. Thanks very much.
Glad it was helpful!
Super tutorial with great teaching style - thanks very much
You're very welcome!
Great tutorial mate 😀 A big help to me... someone who has just been working with MS Office since the 90s 😅
Great to hear!
what if I need to add more details such as positive type, source of funds - is there a way to include that too? thanks a lot
You may need another tool. Charts isn't great for this.
How did you remove the Spreadsheet name and Sheet name? Both are showing when I publish. fantastic tutorial!
Hmm not too sure what you mean here, sorry. Are you publishing from the Chart menu or the spreadsheet?
@@yagisanatode I click on the 3 dots in Chart and then Publish chart.
When you published the link you managed to not show the name of the Spreadsheet and also not the name of the Sheet which is what I also wanted to do as well.
When I publish a link, it has the Spreadsheet name and Sheet name in top left corner.
When I embed into web page (which is what I’m wanting to do for this project) it shows Spreadsheet and Sheet name on top left, and on bottom left it has Sheet name again.
So curious to how you did this!? 👏🏼
@@BG-wo9xz In the example, I jsut displayed the image and in the first dropdown under the link tab, I deselected everything and selected interactive in the next dropdown.
@@yagisanatode thank you so much!!!! 💪🏼
Is there any way to give the same name/title to two different persons in the tree?
You would always need to add something to create a difference. An asterisk perhaps.
Our company is so big that most of it disappears and you cannot scroll to the right to see any more of it .. :(
For sure. Maybe split your image into departments if possible.