View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Pivot (Data Items "Count" vs "Sum")

Excel2003 ... Pivot Chart Data Items appears to default to "Count" ... I wish
this to be "Sum" ... Is there a way to do this before dragging Items from the
Pivot Table Field List to the "Drop Data Items Here" Section ... or ... must
I do this 1x1 after moving to "Drop Data Items Here" Section.

Also ... if there is another option ... I will certainly entertain it ... :)

Thanks ... Kha