Solved

MS Visio align, space and fill

Posted on 2012-03-15
2
742 Views
Last Modified: 2012-03-15
Hello,

I am using MS Visio > Business > Organization Chart. I have almost 250 tasks with tree structure and I choose Visio to make it presentable but now I think it wasn't right chose, as I input each value manually from Excel + in Visio I need to size shape and text block manually as well. Also it is hard to be precise and the end result looks untidy.
My question is: Is there VBA macros which could help me? or Is there a software which could help me make tree structure chart with shapes with data exported from Excel?

Thanks
0
Comment
Question by:SSupreme
2 Comments
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
ID: 37725963
The Visio org chart add-in is actually quite flexible and contains quite a few spacing and layout options -- however, not all of them are easy to find.

In Visio 2010, click the Org Chart tab. On the left end, you'll find a variety of different layout styles you can apply. On the right end, in the Organization Data group, click the Display Options button. On the Option tab you can set the height and width of all shapes at once. Take a look at the options on the Fields and Text tabs too.

Also, don't forget that you can apply themes to add color and style and really make your org chart look nice.

For related suggestions, take a look here: http://taskmap.com/wordpress/category/org-charts-in-visio/
0
 
LVL 16

Author Closing Comment

by:SSupreme
ID: 37727027
I start working with it closely and I see what you mean, thanks.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question