| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linking Combo box to pivot table?
Hi All,
I have a pivot table which has teams on the left, months on the top and a count of the calls in the data area. What I would love is that if I could have a combo box on a worksheet which when I select a team from its list it only shows me that teams data in the pivot table. Is this possible please?? -- Adam ----------- Windows 98 + Office Pro 97 |
|
#2
|
|||
|
|||
|
You could move Team to the page area of the pivot table.
Select a team, and the pivot table will only show its data. Adam wrote: Hi All, I have a pivot table which has teams on the left, months on the top and a count of the calls in the data area. What I would love is that if I could have a combo box on a worksheet which when I select a team from its list it only shows me that teams data in the pivot table. Is this possible please?? -- 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 | |||
| How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
| Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
| create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Linear Mode
