| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Top 20 pivot table shows more than 20
Dear Sirs,
I am using pivot tables where I want to show only the top 20 items. I realised that Excel has difficulties to limit to 20 when the values of each item is little. The referring chart looks really cluttered. Do you know the threshold for this function to work properly? How can I avoid this problem? Regards, Bodo Frost |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for pivot table functionality that shows detail instead of count | Excel Discussion (Misc queries) | |||
| The last row of a pivot table shows blanks, but there is data. | Excel Worksheet Functions | |||
| Pivot Chart which shows average line with below and above figures | Charts and Charting in Excel | |||
| How Do I create a table in excel that shows frequency? | Charts and Charting in Excel | |||
| Counting # of Times an Item Shows Up in a Table | Excel Worksheet Functions | |||
Linear Mode
