Orgcharts by user request

I am currently using Visio to create orgcharts from a dataset within Excel. Ideally I would like my end users to be able to request/create theses themselves by using an app to select the line manager or department they wish to create the orgchart for which would then be run through the wizard automatically and a PDF created and sent to them. I haven't found anything to this affect so far so I'm guessing it's not an available function but any suggestions would be appreciated.