Visio org chart. Need tips for creating 450 associate chart. Am a new user to Visoo 2007

Need to create 450 assoc organizational chart. I'm a new Visio 2007 user. Need to alphabetize all legs. Thanks
chaplynAsked:
Who is Participating?
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
The Visio org chart wizard doesn't provide a way to sort position shapes within a page. In fact, it's slightly worse than that because the wizard decides where to put things on each page. Even if your Excel input is sorted, the wizard will rearrange the shapes on each page as it sees fit.

If you want the pages to be sorted into a specific sequence, you'll need to do that yourself. It would be pretty easy to write a small program to sort the pages based on the page names... if you're interested, let me know. I'd be happy to throw something together.
0
 
Patrick MatthewsCommented:
The easiest way would probably be to place all the data into a pre-sorted Excel file and use the Visio org chart wizard to automatically import and plot the data.

However, *why* do you want to do this?  Unless you will be printing this on a giant banner, it will be unreadable...
0
 
chaplynAuthor Commented:
Thank you Patrick.  i did use the Visio org chart wizard.  The end result gets me 35 pages.  It will not be printed but will be attached as an email file.  i also need to alphabetize the pages and workbook tabs.  Is there a quick way to do that?  Thanks
0
 
chaplynAuthor Commented:
Thanks for your offer but not necessary this time. It took me quite some time but I did the manual sort and sent it out. I'm waiting for comments before arriving at a specific sort. I'll post the request again when I know for sure what's needed. Thanks again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.