View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephen Stephen is offline
external usenet poster
 
Posts: 106
Default Dynamic Grouping

Is there a way to group items in a pivot table dynamically? I was hoping to
that every time I add a date to my data it will be Grouped with it's
corresponding month. For example, if I enter the date 09-26-05, it will be
grouped with the other dates in 'September.' That way, whenever I go to the
pivotchart I can simply select the month and go.