Pivot problems

[Alexandre]

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??

 

[Ken Wright]

Excel -- Pivot Tables -- Dynamic Data Source


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





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