Dashboard from Pivot Charts/Template Suggestion

Hello,

I'm attempting to create a dashboard from the pivot tables I have created, but I'm inexperienced with the process and I'm wondering if anyone can steer me in the right direction.

I'm running reports 2x a week to track course registration by student type per term (i.e. Fall & Summer 2024, 266 New Students, Continuing, Returning students, Registered for 100 credits).

I'm trying to determine if I'm able to take the pivot tables for each day and create another pivot chart to reflect the change in student count and change in registration count.

Essentially, I want to display the data neatly, preferably in one tab, that can be updated with little manipulation. I'm just not certain if this can be done or if I'm not thinking clearly about what I want to do with this report. Any suggestions is appreciated