Thread: create a pivot table and chart from a named range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
  
Posts: 621
Default 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
Reply With QuoteReply With Quote