Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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!!?!?!?!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
drop page fields here and drop series fields here Souris Charts and Charting in Excel 3 January 14th 08 02:38 PM
Pivot Table Page fields Ajit Excel Discussion (Misc queries) 1 October 12th 05 05:49 PM
Pivot Table page fields Chad W. Excel Discussion (Misc queries) 1 July 27th 05 04:27 PM
How to remove Drop Page Fields Here from Pivot Table wengyee Excel Discussion (Misc queries) 2 June 3rd 05 10:36 PM
Pivot Table Page Fields Andy Excel Discussion (Misc queries) 1 December 17th 04 05:25 PM


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"