Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



YouTubersLoveExcel#25: Dynamic Range for Pivot Table & Chart


See how to create a dynamic range for a Pivot Table & Pivot Chart with a Report Filter. The Excel 2007 Table feature automatically creates dynamic ranges that can be used by a Pivot Table and a Pivot Chart.

Also, see how to Filter the whole report with a Report Filter (2007) or a Page Field (2003).





Got a Question? Ask it Here in the Forum.