Automatic updating charts in excel
Use the tools on this tab to make large changes to the way the diagram looks.
The Layout and Arrange groups have tools for changing the layout and hierarchy of the shapes.
The following text gives an example of a comma-delimited text file that has five columns and four rows, with the first row being a header row.
If you don’t want to generate a chart automatically, you can draw a chart without using an external data source.
To start the Organization Chart Wizard, click File When you click to create a chart from the template, the Organization Chart Wizard starts.
On the first page of the wizard, select Information that's already stored in a file or database, then follow the directions in the wizard.
The data source needs to have columns for employee name, unique identifier, and the person the employee reports to.