Field Buttons in Pivot Chart

  • Thread starter Thread starter Gustavo
  • Start date Start date
G

Gustavo

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
 
Select the 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?
 
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
 

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

Back
Top