Field Buttons in Pivot Chart

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
 
D

Debra Dalgleish

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?
 
G

Gustavo

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

Top