View Single Post
  #4   Report Post  
Old March 24th 16, 09:45 AM posted to microsoft.public.excel.charting
[email protected] williamshaitaan@gmail.com is offline
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2016
Posts: 1
Default How to rename a GROUP in a Pivot table

On Thursday, 3 September 2009 20:24:02 UTC+4, 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



Select the group name.
Press F2.
Enter a new group name.

USEFUL LINK:
https://support.office.com/en-us/art...0-0cf0b9b880f7