Solved

MS Visio align, space and fill

Posted on 2012-03-15
2
750 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

738 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