Would like to limit the number of elements in a Pivot Chart filter

nakedbamboo

New Member
Joined
Jun 8, 2015
Messages
9
I am creating a pivot table with a corresponding pivot chart in VBA.I have filtered the data in the table to show only the top 5 values and the chart also only displays the top five values. However, if you click the field filter button on the chart, every value is there and checked by default (even though only five are visible).The problem comes when I want to remove one of the top five from the chart (due to the fact that it is so large it is suppressing the visibility of the other data). If I unselect that item, suddenly every other item becomes visible instead of just the other four items like I would like. I realize this is because all the items are checked in the filter.What I would like to know is why they are all checked by default even though only five are visible and if there is a workaround for this issue (can the filter only show the top five or at least only have the top five checked)?
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,213,534
Messages
6,114,188
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top