I turned a plain Excel pivot table into an interactive dashboard in five minutes
https://www.makeuseof.com/turn-plain-excel-pivot-table-into-interactive-dashboard-in-five-minutes/
How to build a dashboard using PivotTables
Not everything is about fancy charts
Building an interactive sales dashboard from a 1,000-row dataset
It took me all of five minutes