Pivot Chart-Page Fields

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

Guest

Hello,
I have a pivot chart and table with multiple page fields. When hiding items
in the page field, the pivot table shows "Multiple Items", but the pivot
chart shows "All". This happens whether I double click on the page field and
hide an item, or drag it to a row or column area and uncheck the item. I do
not want to users or viewers to think they are seeing All when items are
hidden. Am I doing something wrong or is this a bug?
Thanks for your help!!!
 
I don't know of any way to change the Page field behaviour on the pivot
chart.

However, you could add a text box that displays the contents of the
pivot table page field --

Select the pivot chart
Type an equal sign (You'll see it in the formula bar)
Select the sheet that contains the pivot table
Click on the cell that contains the page field dropdown
Press the Enter key

A text box will appear in the centre of the pivot chart
Drag it to the top of the pivot chart, near the page field.
Format the text box, using the buttons on the formatting toolbar.
 
Back
Top