Excel file into Visio Org Chart wizard formatting

S

Steve Eagle

In Visio 2003, when importing an Excel file into the Org Chart wizard, is
there a way to define formatting of the org chart boxes like the color?

There is a field called "Master_Shape" with the numbers 0 thru 6 as options
for each row. However, this only seems to effect the outline and not the
color.

Is there a default template that can be changed so the "Master_Shape"
numbers will map to it?
 
J

John... Visio MVP

Steve Eagle said:
In Visio 2003, when importing an Excel file into the Org Chart wizard, is
there a way to define formatting of the org chart boxes like the color?

There is a field called "Master_Shape" with the numbers 0 thru 6 as
options
for each row. However, this only seems to effect the outline and not the
color.

Is there a default template that can be changed so the "Master_Shape"
numbers will map to it?
Click to expand...

No there is not, but there is a possible work around.

Add an extra column to the Excel spreadsheet to indicate colour and then
import that into the orgchart. each shape will now have an extra custom
property to indicate colour.

Now the tricky bit. You will need some VBA code to loop through the shapes
on the page and if the shape has a custom property with the same name as the
extra column, you can then change the shapes colour. Your choice as to
whether it is the Line or the Fill colour ( or both )

John... Visio MVP
 
Top