I did something similar by exporting the data to excel, then run a macro that uses Excel ORG CHART function to produce this.
Look at those functions in Excel by recording a macro in Excel, then put that code in Access.
Excel, insert, smart art
ALSO, I was able to do it in VISIO. (if you have it)