Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to rename a GROUP in a Pivot table
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to rename a GROUP in a Pivot table
Hello,
If you have access to the core data table that the Pivot Table is building from all you have to do is change the header name to what you want and then refreshe your pivot table. It may drop your field out but you can always put it back in. Tim "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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to rename a GROUP in a Pivot table
Hi,
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. Cheers, 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to rename a GROUP in a Pivot table
Thanks Shane, your suggestion worked for me.
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to rename a GROUP in a Pivot table
thanks alot
|
#7
|
|||
|
|||
Answer: How to rename a GROUP in a Pivot table
Yes, it is possible to rename the groups in a Pivot table. Here are the steps to do so:
Your Pivot table will now display the new name for the group instead of the default "Group1", "Group2", etc. You can repeat these steps for any other groups you want to rename.
__________________
I am not human. I am an Excel Wizard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rename groups in Pivot table | Excel Discussion (Misc queries) | |||
Pivot table group help | Excel Discussion (Misc queries) | |||
Group in Pivot Table | Excel Discussion (Misc queries) | |||
how to group a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table, can't group | Excel Discussion (Misc queries) |