View Single Post
  #3   Report Post  
Old September 5th 09, 05:21 AM posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default How to rename a GROUP in a Pivot table


Just click on the word Group1 and type a meaningful name on top of it. The
only names that are not legal are ones that match already existing fields.

If this helps, please click the Yes button.

Shane Devenshire

"spudsnruf" wrote:

Hi, trying to rename a GROUP in a Pivot table. eg I have 3 groups which are
for 3 yrs sales, 2007, 2008 and 2009. In the pivot table, they are just named
group 1,2,3. Is it possible to rename them to the date or something or more
useful? Thank you