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