Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-08-2014, 07:19 AM
DSS90 DSS90 is offline Formatting an Org. Chart (SmartArt) to fit in a page Windows Vista Formatting an Org. Chart (SmartArt) to fit in a page Office 2010 32bit
Novice
Formatting an Org. Chart (SmartArt) to fit in a page
 
Join Date: Oct 2014
Posts: 3
DSS90 is on a distinguished road
Default Formatting an Org. Chart (SmartArt) to fit in a page

I have to create a very large organizational chart with well over 60 divisions/sub-divisions. When I attempt to format it, I can clearly see that there is more than enough room to resize the boxes and move them around to allow for some breathing room and readability. However, I am having trouble adjusting the SmartArt to fit in a page. Is there any way to adjust the size of the boxes to make better use of the available space? Is designing such a chart on Word/Excel even possible or should I consider a different program? I’ve attached the screenshot and file for reference.



Thanks for the help!
Attached Images
File Type: png image.png (215.9 KB, 33 views)
Attached Files
File Type: xlsx Org Chart Format.xlsx (108.0 KB, 18 views)
Reply With Quote
  #2  
Old 10-08-2014, 07:12 PM
thetraininglady thetraininglady is offline Formatting an Org. Chart (SmartArt) to fit in a page Windows 7 64bit Formatting an Org. Chart (SmartArt) to fit in a page Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

Generally with an org chart of this scale I would recommend using a separate program. Microsoft Visio is a good one and provides some better tools to be able to construct an org chart containing this many elements.

Your other option if you really want to use a program from the Office suite is to possibly use PPT to create your main org chart showing your Main branches and then use hyperlinks to link each "branch" through to a different slide which would have the rest of the hierarchy in more detail. I'm attached a sample file so you can see what i mean (I've only hyperlinked items 1, 2 and 3).

Hope this helps.
Attached Files
File Type: pptx Linked Org Chart.pptx (101.8 KB, 29 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting an Org. Chart (SmartArt) to fit in a page Formatting an Org. Chart (SmartArt) to fit in a page DSS90 Drawing and Graphics 3 10-08-2014 08:15 AM
Gantt chart bar formatting summ vs recurr task Intruder Project 1 02-02-2014 08:19 AM
SmartArt - Add shape below - across saslotteroy PowerPoint 0 03-17-2013 03:37 PM
Animating SmartArt Cosmo PowerPoint 0 07-13-2012 07:15 AM
Formatting an Org. Chart (SmartArt) to fit in a page Page breaks inserted in Gantt chart have no effect Steve Sells Project 2 11-09-2005 08:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft