View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
SteveG
 
Posts: n/a
Default 12 month pivot table


Acro,

I assume you mean subtotals and not row totals. Either way, right
mouse click on your pivot table and select Table Options from the menu.
To remove the subtotals, deselect the "Subtotal hidden page items".
You can also remove the Grand totals for rows and Grand totals for
columns. Make sure that your named ranges reflect the correct data as
well. (chtCats, chtVal, chtLen)

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=552411