create a pivot table and chart from a named range
 

Hi,
All I really want to accomplish is to take a range, called
'MasterTable' and click a button which creates a new blank pivot table
and a blank chart (chart within the same sheet as pivot table).

Any help would be appreciated.

Thanks,
Steve

create a pivot table and chart from a named range
 

All you need is at Jon's site.

http://peltiertech.com/Excel/Pivots/


Gord Dibben MS Excel MVP

On Mon, 6 Jun 2011 20:36:18 -0700 (PDT), SS wrote:

Hi,
All I really want to accomplish is to take a range, called
'MasterTable' and click a button which creates a new blank pivot table
and a blank chart (chart within the same sheet as pivot table).

Any help would be appreciated.

Thanks,
Steve