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.