MENU

Fun & Interesting

How to Create a Dashboard Using Pivot Tables and Charts in Excel (Part 3)

Excel Campus - Jon 2,559,548 10 years ago
Video Not Working? Fix It Now

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ http://www.excelcampus.com/charts/pivot-tables-dashboards-part-3 This is part 3 in the series on Pivot Tables and Dashboards. In this video we bring it all together to create the interactive dashboard. 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. You can download the file to follow along at the following link. http://www.excelcampus.com/charts/pivot-tables-dashboards-part-3 Please subscribe to my free email newsletter to get your tutorials like this and get updated about PivotPal. Get PivotPal: http://www.excelcampus.com/pivotpal WATCH PART 1: https://www.youtube.com/watch?v=9NUjHBNWe9M WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y Subscribe to my free newsletter: http://www.excelcampus.com/newsletter

Comment