Home |
Search |
Today's Posts |
#1
|
|||
|
|||
automating a pivot table
When using a pivot table, is there any way of
automatically selecting from a drop down menu. By this I mean if I can select one of 5 colours, If I put "red" in cell A1, can the pivot table be made to take the value in cell A1 as the colour selection, rather than me selecting red from the drop down list. thanks in advance |
#2
|
|||
|
|||
You can add fields to the page area. When you select from the dropdown
list in a field there, the table is filtered to show only that item. bobf wrote: When using a pivot table, is there any way of automatically selecting from a drop down menu. By this I mean if I can select one of 5 colours, If I put "red" in cell A1, can the pivot table be made to take the value in cell A1 as the colour selection, rather than me selecting red from the drop down list. thanks in advance -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a formula to a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |