Pivot Table Label
Is there any way to Label a Pivot table so that the label changes when you
change the pivot table. i.e. Your pivot table deals with sales of widgets, and you have a column for months. You only select March, April, and May. Is there any way to label your pivot table, Wiget Sales for (Months Selected)? Thanks |
Select the three months and select data, group and outline, group. Then
rename the group label by typing over it in the formula bar. Gary "Dustin" wrote: Is there any way to Label a Pivot table so that the label changes when you change the pivot table. i.e. Your pivot table deals with sales of widgets, and you have a column for months. You only select March, April, and May. Is there any way to label your pivot table, Wiget Sales for (Months Selected)? Thanks |
Gary are you talking about going back to the base data and grouping and
outlining that? I dont guess I understand, I was unable to group and outline a pivot table. I am trying to use data from the pivot table using getpivotdata on another sheet, and each time the pivot table changes i would like for the label thats describing the numbers that are represented to change as well. "Gary Rowe" wrote: Select the three months and select data, group and outline, group. Then rename the group label by typing over it in the formula bar. Gary "Dustin" wrote: Is there any way to Label a Pivot table so that the label changes when you change the pivot table. i.e. Your pivot table deals with sales of widgets, and you have a column for months. You only select March, April, and May. Is there any way to label your pivot table, Wiget Sales for (Months Selected)? Thanks |
All times are GMT +1. The time now is 10:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com