And I have a second challenge: I would like to have four different org-charts in one visio file. all four charts are based on 4 different tables in excel ( one chart for each department). any idea how to achieve this?
You can create multiple queries using PowerQuery / Data | Get & Transfor Data, then use these for the source of different org charts on separate worksheets
Hi David, nice video-series of visio data vizualiser. Do you know if its possible to change the default colors of different role types in an visio data visualizer org-chart? i was able to change the underlying list of roles based on our internal role structure, but now all shapes have the same blue colorcode. I wasnt able to find editing of colorcodes of the shapes based on role types.
The default colors are just using the page theme. If you want to color by department or anything else, then open in Visio Desktop and select the data row in the Data Graphics panel (with no shapes selected) then tick to apply Data Graphics, and chnage it to Color By Value, then Configure