I would like to use an Excel data table to store employee information, then
automatically update an organisation chart.

This seems a logical solution with a large group where employees change
teams, managers change. However, I can not see a way to do this in Excel or
any solutions posted on the web.

I've seen websites diagramatically display org structures that are obviously
based on data, but do not want to use a dedicated program or write complex
code to create and link objects.

Any advice greatly appreciated