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?
Click to expand...
 
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
 
Back
Top