Pivot problems

Hi I am currently making a graph off of a pivot,
my pivot changes in size every month and i would like to find a way to
make my graph adjust to the new size of the pivot table,

i also have a column on the side of the pivot table having a
function i also wish to adjust to the pivot size.

any hints or resources i could use??

Excel -- Pivot Tables -- Dynamic Data Source


1. Pivot Tables -- Introduction
Getting Started
Use a Dynamic Data Source





http://www.contextures.com/xlPivot01.html

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Alexandre" <[email protected]> wrote in message
news:[email protected]...
> Hi I am currently making a graph off of a pivot,
> my pivot changes in size every month and i would like to find a way to
> make my graph adjust to the new size of the pivot table,
>
> i also have a column on the side of the pivot table having a
> function i also wish to adjust to the pivot size.
>
> any hints or resources i could use??
>