View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
[email protected] williamshaitaan@gmail.com is offline
external usenet poster
 
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