ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Data Filter Pane (https://www.excelbanter.com/excel-discussion-misc-queries/170015-pivot-data-filter-pane.html)

PatK

Pivot Data Filter Pane
 
Hey....dumb question (I fear): When working with a pivot table/chart in
excel 2007, a "floating" pane appears when I click on the chart of the table,
and I "think" it is called Pivot Data Filter Pane or somesuch. I cannot say
for sure, as it is somewhat of an irritant and in the way, most of the time,
so I close it.

But now, I want to open it, and cannot find out how to do it. There is no
verbiage about it in the help. It is like it does not exist.

Can anyone tell me how, once it has been closed, to bring up this filter
pane, again?
Thanks!

Patk

Laura Cook[_2_]

Pivot Data Filter Pane
 
Not sure, are you talking about the Field List? If so, click on the pivot
table, and under "PivotTable Tools" on the toolbar, click on "Options".
From there, on the far right side of the toolbar, select "Field List".

Laura


"PatK" wrote in message
...
Hey....dumb question (I fear): When working with a pivot table/chart in
excel 2007, a "floating" pane appears when I click on the chart of the
table,
and I "think" it is called Pivot Data Filter Pane or somesuch. I cannot
say
for sure, as it is somewhat of an irritant and in the way, most of the
time,
so I close it.

But now, I want to open it, and cannot find out how to do it. There is no
verbiage about it in the help. It is like it does not exist.

Can anyone tell me how, once it has been closed, to bring up this filter
pane, again?
Thanks!

Patk





All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com