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?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top