Visio 2007 - Creating multiple page org chart from excel datasource

[BoboBarlow]

Hi all,

I am very new to Visio (and this website) but I've been having a play around with it to try and see what it can do! One of the things that I can't seem to find (and I'm not sure whether or not functionality exists) is the ability to create an org chart (using the wizard) from a datasource containing multiple worksheets. The reason for doing this is to show splits within the organisation and have seperate sheets that reflect this.

Can this be done? If so, does anyone have any thoughts on how?

Thanks in advance

John