Pivot Chart Drop Page Fields Here

  • Thread starter Thread starter Fishbone
  • Start date Start date
F

Fishbone

I have used the Pivot Chart function and it works terrific. However, there is
a Drop Page Fields Here that I do not want to show when I copy and paste this
into Powerpoint. Help!!?!?!?!
 
Select the Pivot Chart
I have used the Pivot Chart function and it works terrific. However, there is
a Drop Page Fields Here that I do not want to show when I copy and paste this
into Powerpoint. Help!!?!?!?!
Click to expand...
 
Debra (or anyone),
Is there a way to hide ONLY the field I don't want to see?
Specifically the field that is showing where the chart title should be
located (top middle). I need to keep my other 3 fields.
 
No, you can hide all the field buttons, but not just specific ones.
 
As an FYI for anyone else who might read this thread, I found a way AROUND
hiding the field I don't want to see [Specifically the field that is showing
where the chart title should be located (top middle)]. Here's what you do .
.. .

Simply get a screen capture of the print screen of your chart (as this
annoying "drop page fields here" bar does NOT print). Then crop out the
portion of your background where the annoyance would normally be located.
Then paste this "image" on top of the annoyance in your pivot chart.

Viola! You've hidden what could not be singularly hidden.
 
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 (Data Items "Count" vs "Sum") 2
How to remove Drop Page Fields Here from Pivot Table 2
Pivot Table/Chart Formatting 1
Pivot Charts 3
pivot table chart 7
Refresh pivot chart when info in a cell changes 1
Copying Sheet with Pivot charts 3
Pivot Chart Trendline? 0

Back
Top