A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Field Buttons in Pivot Chart



 
 
Thread Tools Display Modes
  #1  
Old January 9th, 2004, 04:54 PM
Gustavo
external usenet poster
 
Posts: n/a
Default Field Buttons in Pivot Chart

Hello everyone,
I created in Excel 2000 a Pivot Chart based on a pivot
table in a different worksheet.
The graph works beautifully for my purpose but there's a
couple of things I need to get rid of.
1)The Field buttons that I do not need to use to select
data and
2)The little and in this case annoying box saying "Drop
More Series Fields Here"
If I remove the button that I do not need then the graph
gives me a summary of data, just like a normal pivot
would do and I know this is by design but I was wondering
if I can just hide it.
Does anyone know how to do this or if it is possible at
all?
I thank you in advance
Gustavo
  #2  
Old January 9th, 2004, 06:30 PM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default Field Buttons in Pivot Chart

Select the chart
On the PivotTable toolbar, click the PivotChart button
Choose 'Hide PivotChart Field Buttons'


Gustavo wrote:
Hello everyone,
I created in Excel 2000 a Pivot Chart based on a pivot
table in a different worksheet.
The graph works beautifully for my purpose but there's a
couple of things I need to get rid of.
1)The Field buttons that I do not need to use to select
data and
2)The little and in this case annoying box saying "Drop
More Series Fields Here"
If I remove the button that I do not need then the graph
gives me a summary of data, just like a normal pivot
would do and I know this is by design but I was wondering
if I can just hide it.
Does anyone know how to do this or if it is possible at
all?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3  
Old January 12th, 2004, 04:37 PM
Gustavo
external usenet poster
 
Posts: n/a
Default Field Buttons in Pivot Chart

Thanks for your response Debra but that hides all the
field buttons and the graph gives me a summary like I
explained before.
I guess it can't be done but anyway thanks again.
Gustavo

-----Original Message-----
Select the chart
On the PivotTable toolbar, click the PivotChart button
Choose 'Hide PivotChart Field Buttons'


Gustavo wrote:
Hello everyone,
I created in Excel 2000 a Pivot Chart based on a pivot
table in a different worksheet.
The graph works beautifully for my purpose but there's

a
couple of things I need to get rid of.
1)The Field buttons that I do not need to use to

select
data and
2)The little and in this case annoying box

saying "Drop
More Series Fields Here"
If I remove the button that I do not need then the

graph
gives me a summary of data, just like a normal pivot
would do and I know this is by design but I was

wondering
if I can just hide it.
Does anyone know how to do this or if it is possible

at
all?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.