How to remove Drop Page Fields Here from Pivot Table

  • Thread starter Thread starter wengyee
  • Start date Start date
W

wengyee

Hi,
When I make a chart using a pivot table I see a blue rectangle box at
the top that says 'Drop Page Fields Here'. Is there a way I can hide
this box so that I can copy the entire chart to powerpoint.

Currently, when I do this, the 'Drop Page Fields Here' box gets copied
over as well thus making it look meaningless in powerpoint.

Thanks.
 
The only option I've found is to use the Pivot Table toolbar while on the
chart page , click the Pivot Chart button & choose Hide PivotChart Field
Buttons. Unfortunately you then have to add your own axis labels.

HTH |:>)
 
Try using Edit-Paste Special in PowerPoint and selecting Enhanced Metafile.
This will copy the chart but doesn't include the pivot table placeholders.
 
You must log in or register to reply here.

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 Chart Drop Page Fields Here 5
Pivot Table/Chart Formatting 1
2003 Pivot Table Filter (items dropped in the Page Fields) 1
Pivot table drop downs not refreshing 1
Pivot (Data Items "Count" vs "Sum") 2
What is "drop page fileds here" for in a pivot table? 2
pivot tables 1
Pivot Table Drop Downs 3

Back
Top