Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS Visio align, space and fill

Posted on 2012-03-15
2
Medium Priority
?
769 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 31

Accepted Solution

by:
Scott Helmers earned 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

916 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