Excel 2007 Pivot Chart automatically display last 6 months

Hi

Is there away to have a Pivot chart automatically limit its output to say the previous 6 months rather than all available dates?

Many thanks

you could have an extra column within your data set to use as a page filter which limits the data

for example test for the month - 6

label the column something like - Months to Show

then assuming the date you want to test is starting in Cell B2,

then use
=B2>=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY()))

copy down the data set
use a table and it will automatically be inserted when you append new data

then use that column in the page filter and say True