Visio Guy

Solution-specific Visio Discussions => Org Charting => Topic started by: KDavidP1987 on September 24, 2020, 03:54:42 PM

Title: Org Charting off Budget Data
Post by: KDavidP1987 on September 24, 2020, 03:54:42 PM
Hi everyone,

Needing some help!

I have basic skills in developing org charts in Visio. I've helped around the office here and there with diagrams, flow charts, and org charts as needed, so over time more people started coming to me expecting that I am a Visio wizard when in reality it's just been A LOT of trial and error learning mixed with a dose of personal OCD mostly. LOL

Introductions aside, my manager has given me a task to develop org charts based off budgeting data, with the hierarchy secondary. Here are the basic criteria for this endeavor:


I've never undergone an endeavor in Visio of this nature. I have my Budget Org Data cleaned and ready for import in Excel, by utilizing Power Query to automatically import and clean the data.  I've tested importing the data into an org chart and it all imports correctly from a hierarchical perspective.  I primarily need help understanding how I can set it up to separate pages per Cost/Profit Center automatically upon import, and be updatable with new info as the data changes. 

All of the videos I see online seem to be of simple org charts using traditional organizational datasets or exchange to pull info.  I can't find any info on separating org chart pages by alternative variables in the dataset, or on keeping them cleanly updated for automation.

Please provide me with some ideas, or point me in the right direction. If you have a solution outside of Visio that could work for this I am open to options as well.

Thank you for your time and guidance!