Visio has a lovely wizard that lets you automatically create an org chart from an Excel spreadsheet, or directly from Exchange.
However, if you have a large number of people, the wizard likes to chop up your tree into many pages, based on its own understanding of what will fit.
I actually want one single enormous tree on one enormous page. The wizard does not appear to handle, this, but it's actually really possible.
However, if you have a large number of people, the wizard likes to chop up your tree into many pages, based on its own understanding of what will fit.
I actually want one single enormous tree on one enormous page. The wizard does not appear to handle, this, but it's actually really possible.
- Create a dummy org chart:
- Click New.
- Choose the template named Organization Chart Wizard, then click Create.
- Follow the steps to create the org chart from your data source.
- Delete the org chart that was created.
- Click Design, Size, than choose the page size and orientation that you want. For example, switch to A3 landscape.
- Create the real org chart:
- Click the Org Chart tab.
- Click Import to open the Org Chart Wizard again.
- On the penultimate wizard page, choose I want to specify how much of my organization to display on each page.
- On the last wizard page, ensure that only the most senior person appears in the Employee at Top of Page table.
- Click Finish.