Data Model

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

How to Quickly Create Time-Series PivotCharts by Robert Walker

Time-Series charts are a staple data visualization tool in many industries.  Creating easy to manipulate time-series charts has been done for a while online (i.e., Plotly.js, Tableau), many clients require their data to stay "local" - either Excel or a secured database - nothing online or 3rd party.  That's where Excel PivotCharts can fill the gap.  This tutorial will show you how to accurately present time-series data using a PivotChart.

Read More