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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|