Pivot Table Label

D

Dustin

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
 
G

Gary Rowe

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
 
D

dustin

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.
 
Top