View Single Post
 
Old 11-03-2021, 06:34 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Yes it is possible.

I assume you have been using the Org Chart Wizard to build your charts. If so, you can specify the executive at the top of the page and all their underlings will appear on the chart. You can define the wanted sections and remove the top level charts from the last couple of steps with the Wizard.

You can also create a copy of the data source and delete the rows you don't want in your chart before pointing the wizard at that new data source.

Finally, you can create a macro in Excel that sends the data you want to the Visio drawing of your choice. This is not an impossible undertaking but it is quite involved if you aren't used to automating applications via VBA.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote