Tag: Pivot Charts

I recently worked on a project that had three distinct and large datasets for different geographical areas in three workbooks.  Starting with the first workbook and dataset in a Table in its own worksheet, I created a worksheet of seven …

VBA to Change Pivot Table Source Read More »

Tagged with: , , ,

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 …

Tip for excluding Outlier data in Pivot Charts Read More »

Tagged with: , , ,

In past posts I have talked about a ‘database’ approach or how an Excel  data analyst approaches data in their spreadsheeting or financial modelling.  Anyone from an IT background would say this right.  But I came from an accounting and …

Organise data like an Excel Analyst Read More »

Tagged with: , , , , ,