Tutorial:How to Create a Dashboard Using Pivot Tables and Charts in Excel (Part 3)
You will learn how to: Group dates into months and years to create a time series trend chart Group amounts to create a distribution (histogram) chart. Add slicers to your pivot tables and charts to make them interactive. Lots of tips and shortcuts for formatting your charts.
https://youtu.be/FyggutiBKvU?si=ARtif9yyCmB2_qxD