Hello,

I'd like to create a dynamic Bar of Pie chart - using a Pivot Table. I've done so - but the 'Other' pie slice/bar chart isn't fixed. In that, I need 2 particular values to always be combined as the 'Other' pie slice.

I arrange it fine - formatting the data point "Custom", placing the correct slices on the First and Second Plot - but when I filter my pivot data differently - different values compose the OTHER section.

???