Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to remove Drop Page Fields Here from Pivot Table
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. |
#2
|
|||
|
|||
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 |:) "wengyee" wrote: 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. |
#3
|
|||
|
|||
Try using Edit-Paste Special in PowerPoint and selecting Enhanced Metafile.
This will copy the chart but doesn't include the pivot table placeholders. "wengyee" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically print all page contents in pivot table. | Excel Worksheet Functions | |||
Pivot Table Page Field | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
How do I refresh a PivotTable and remove outdated page field entr. | Excel Discussion (Misc queries) | |||
Pivot Table Page Fields | Excel Discussion (Misc queries) |