How am I supposed to look through this chart if I can't pan through it or zoom in/out? Am I just supposed to make it big enough on the sheet and then scroll through the sheet?? Seems so stupid.
I would suggest to do the following:
Customize an organizational chart
Double-click the chart you want to change.
At the right, click Customize and then Org.
hange the size or color of the boxes.
Adjust the size of the chart image (make sure that it will show the complete organizational chart that you want to see)
To zoom-in/zoom-out, please use the default zoom option in the sheets, example 90% zoom.
Sample:
May be you try to move the chart to the second page? On the second page you will have lot of space for zoom in.
Update:you want to get dynamic zoom literally? I'm afraid this is impossible here. Try to consider the option with SaaS-tool with free account like Zenflowchart, find solution in Awesome DataViz or Awesome BI.