@cb23 you would still need to manually update the Visio chart.
At best you could have a Table1 in excel or sharepoint, and a power automate flow that looks for changes in the source of all employee information or where ever. So basically you are keeping Table1 updated with employee data.
I know Visio can link to an Excel table, but it is linking specific images to rows in the table. It can't add new images simply by an update. (I think it can get close but you pretty much need to be a Visio programmer to understand that.) Even then, it can't arrange things properly.
However, let's say you will always have the exact same org chart of departments and positions. So you are only swapping people's names into positions or listing them as vacant. You could have the Excel table updated with power automate. But then you need to open the Visio and update it through the link, you can't do that with Power Automate.
On top of that, you probably need to make it a pdf or something to post it. I don't really know how you have it to be viewed.
I like to think that anything is possible, but Visio is a nightmare. Trust me, I worked on the exact thing last year. There's a reason Microsoft doesn't really promote it. And there is a difference between the Desktop Version and the O365 Version.
Maybe I didn't know enough about Visio to make it work correctly. But I did give it a good try, but gave up on it as being any sort of automated.
An alternative to Explore would be using a Power BI. That still wouldn't be easy, but it would probably get you closer to an automated system than Visio.
