Solved

MS Visio align, space and fill

Posted on 2012-03-15
2
733 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
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 longer labels with horizontal bar charts instead of the vertical column chart.

809 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