Display Concated Shape Data on Org. Chart Shape

-Polak
-Polak used Ask the Experts™
on
Currently my org chart is linked to an excel database, there I have 3 columns concatenated so that a 4th column reads X"-"Y"-"Z. In Visio I have this concatenated 4th column display on the shape.

Is there any way I can have the 3 columns concatenated on the shape so I can delete this repetitive data out of the excel sheet?

Would need to have it display with the "-" when imported.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Visio Consultant, Trainer, Author, and Developer
Most Valuable Expert 2011
Commented:
You could accomplish what you're asking by running a macro after running the org chart wizard, however, I'm not sure it's necessary.
What about this instead:
  • Use a formula to populate the cells in the concatenation column in Excel, e.g.:
    =C2&"-"&D2&"-"&E2
  • Hide the the concatenation column in the Excel workbook
  • Visio can still see the hidden column, so tell the org chart wizard to display the concat. column on each shape
By doing this, the data in the concatenation column will be generated automatically but you won't see see it (formulas in hidden cells do recalculate, by the way) and Visio will display what you want with no extra work.
Regards,
Scott
 

Author

Commented:
Alright that's what I was currently doing, just looking for an cleaner way, but I don't want to mess around with macros with something like this.
Scott HelmersVisio Consultant, Trainer, Author, and Developer
Most Valuable Expert 2011

Commented:
Sorry that I can't think of anything that doesn't involve a macro... if I have a brainstorm, I'll let you know.

Author

Commented:
Alright, problem is that the shapes auto-size on import so if you import a 5 field shape, and then concat 3 of the fields via a macro the shapes are too large and you have to code another macro to resize them, just becomes clunky.
Scott HelmersVisio Consultant, Trainer, Author, and Developer
Most Valuable Expert 2011

Commented:
It would be easy enough to do both things in one macro, but I agree that having to use a macro at all is less desirable.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial