Pivot problems

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alexandre - 10 Jun 2005 15:46 GMT

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

Reply to this Message

Ken Wright - 12 Jun 2005 09:46 GMT

Excel -- Pivot Tables -- Dynamic Data Source

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

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

Signature

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

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

> 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
[quoted text clipped - 4 lines]
>
> any hints or resources i could use??

Reply to this Message