Pivot

Time-Series PivotCharts with Dynamic Date-Axis by Robert Walker

Using PivotCharts in Excel is a powerful analysis, automation, and visualization tool - however, they are lacking when it comes to Time-Series charts and require a bit of trickery to work as expected.  Here I describe some of those tricks and provide a working example of how to make dynamic time-series PivotCharts.

Read More