View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
rexmann rexmann is offline
external usenet poster
 
Posts: 79
Default Grouping in Excel

Hi

I have a Pivot table which has the data in dates in drop row fields here and
a count against drop data here.

I have then used grouping to put the months together (jan feb march etc).
However if I add new data to the pivot I want the pivot table to
automatically add the data to the correct group when I refresh.

Is this possible? I can get it to do this

Any help greatly appreciated

Kind regards

Rexmann