View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff T[_2_] Jeff T[_2_] is offline
external usenet poster
 
Posts: 1
Default Chart help please

I have a 2 level pivot table. Is there away for the Sub Total for each top
level group to display on the chart?
For instance, this is a portion of the pivot table, I want the Chris Bowen
Total and Duc Le Totals to show up next to the Individual PM totals.
I know I can recreate the information, but would rather not.
Thanks!


Count of PROJ_NAME
Sup PM PM Total
Chris Bowen Chris Bowen 11
Edward Wortmann 5
Gary Nelson 22
Henry Warden 18
Norman Bissenden 7
Ronald Savage 10
Stacie Sheeley 13
Timothy Thury 3
Chris Bowen Total 89
Duc Le Adrien Turner 12
David Weber 24
Luke Shipley 5
Montrell Harris 2
Tuan Nguyen 8
Duc Le Total 51