pivot tables excel 2007

Hi is there a way to filter a pivot from another sheet? i have a graph / dashboard in one sheet and i want to enter 3 filter values in that sheet to filter a pivot in another tab. rather than entering tab 2 adjust the values then going back to see the results. i know there is a way just not...

Hi All I am trying to create a dashboard at present using a large set of raw data. I have created pivot charts using the data to represent it for varying metrics. However, I now need to have the 3 sets of raw data populate automatically under each graph. I had planned to do this using...

<tbody> <tbody> Date </tbody> <tbody> Account </tbody> <tbody> Description </tbody> <tbody> Dr </tbody> <tbody> Cr </tbody> <tbody> 01-09-14 </tbody> <tbody> Employee A </tbody> <tbody> Salary payable </tbody> <tbody> 40000 </tbody> <tbody>...

I have a macro that updates a series of pivot tables based on a field selection in the pivot table, for example, in the page filter I select the 'sales region' (North, South, East, or West) and in the 'product' (apples, oranges, pears or bananas). It works great as long as there is data to...

Hi, On this website at the link below, it shows and explains exactly what i am trying to do, but the steps are given in an older version of Excel, and i would like to know how to do the same exact thing but in Excel 2007, does anyone know how to do it or have the steps? Please share, thank you...