Pivot Table Label

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table Help 1
Pivot Table Data Column Sort Excel 2007 1
Value filter missing in pivot table 3
Headings for Sum in Pivot Table. 5
Office 2007 Pivot Table Display format - Show row headings in each 1
about pivot table 1
Excel 2007 Pivot Table Question 2

Back
Top