ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Chart Drop Page Fields Here (https://www.excelbanter.com/excel-discussion-misc-queries/187100-pivot-chart-drop-page-fields-here.html)

Fishbone

Pivot Chart Drop Page Fields Here
 
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!!?!?!?!

Debra Dalgleish

Pivot Chart Drop Page Fields Here
 
Select the Pivot Chart
On the PivotTable toolbar, click
PivotChartHide PivotChart Field Buttons

Fishbone wrote:
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!!?!?!?!



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


Fishbone

Pivot Chart Drop Page Fields Here
 
Thank you!!!!

"Debra Dalgleish" wrote:

Select the Pivot Chart
On the PivotTable toolbar, click
PivotChartHide PivotChart Field Buttons

Fishbone wrote:
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!!?!?!?!



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



Ray - VPC Rookie

Pivot Chart Drop Page Fields Here
 
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.

Debra Dalgleish

Pivot Chart Drop Page Fields Here
 
No, you can hide all the field buttons, but not just specific ones.

Ray - VPC Rookie wrote:
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.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


Ray - VPC Rookie

Pivot Chart Drop Page Fields Here
 
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.


All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com