View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bikash Bikash is offline
external usenet poster
 
Posts: 6
Default 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