Tip for excluding Outlier data in Pivot Charts
Last week I implemented Pivot Charts for a client with three very large data sets, one of which was 30K rows and the other two being > 10K rows. There was one obvious outlier skewing one of the charts but who knows over time there might be others. What could be an easy simple way …