Tip for excluding Outlier data in Pivot Charts
The idea being if the user wants to exclude a certain row’s data because it’s an outlier, this can be easily marked as so in the source data Table dataset by entering ‘X’. Then on the Pivot Table the field also called ‘X’ was chosen in the Filter section of the Pivot Table field list. Then blanks are chosen in that Pivot Table’s filter so any rows marked ‘X’ are excluded. This can easily be reversed by deleting the ‘X’ entry later or temporarily by changing the filter in the Pivot Table to include all. Ok the fact my Header was called “X” and the rows to be excluded are marked “X” might be a bit confusing but I didn’t want the heading name in the Filter section to be prominent in the chart’s final appearance. You could just as well make this heading “d”, “” or “.” instead.
I found this to be a simple, effective and practical way to exclude Outlier data.