Excel Dashboard - Interactive

Hi.

I have to build an Excel dashboard to share with Senior Leadership. I can't build it in Power BI as licenses are limited and I am not allowed access to a workspace to publish for those without licenses.

The data set is taken from our IT self service ticket system. I have it formatted as a table with a few helper columns to cleanse issues.

I need to present info on tickets by:

-directorate

-divisions

-ticket category

-status (open or closed)

-length of time open or by length time to resolve when closed.

-It has to be visual and not just pivots so needs graphs etc.

-It needs to be interactive in a way that the one workbook with the data and dashboard will be available to the Senior Leadership of each directorate or division, who need to be able to filter or use a slicer to amend the visuals for their own areas, and then go to the data set to see only those tickets.

(1) i can create pivots tables and charts based on the table, and then slicers based on these, but they don't modify the table which is a requirement.

(2) I can create slicers directly from the table which will modify it but then I can't connect these to a pivots table or chart to modify them on the dashboard itself.

(3) this will be saved on sharepoint so I can't use any macros if they are a solution, and it has to be dummy proof - with all the goodwill in the world, someone will make a fuss if they can't see something or do something, and it will come back to bite me.

Has anyone any ideas on how I can do this? I've tried searching for templates etc but I can't really work out the best way of doing this? I always thought i was pretty decent at Excel but dashboards are not something I would ever really create to be honest.

Thanks in advance