Charting a pivot-table problem
 

Hello, I am not sure if this is possible:

I have a pivot table that automatically updates itself when a macro i
run. I then have an automatic pivot-chart that graphs the numbers i
the pivot-table by date.
The table runs from B4: onwards, depending upon the extract it is base
on, ie: longer extract will have more dates.

There is always a fall off on the right hand-side of the graph becaus
the data is not up to date for the latest dates in the range.


Is there a way to tell Excel t0 miss out the last 30 days from th
range. Eg: if your last date value was 1st October, the macro will tel
Excel to show only up to 1st September. That way the fall off in th
information will not be shown in the graph.

Thanks in advance for your help

Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=27021