Excel Forum



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.