ExcelBanter - Value Filter menu is gray except for Top 10 in Pivot Chart 2007

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Value Filter menu is gray except for Top 10 in Pivot Chart 2007 (https://www.excelbanter.com/charts-charting-excel/140463-value-filter-menu-gray-except-top-10-pivot-chart-2007-a.html)

Sam

Value Filter menu is gray except for Top 10 in Pivot Chart 2007

I want other filtering options than Top 10 using the Pivot Chart in Excel
2007, but the options are all grayed-out. What do I need to do to make those
Value Filter options available?

All times are GMT +1. The time now is 06:44 AM.