In this post, I show how to make a 3 variable time series panel chart in R. As an Excel panel chart pioneer, I can tell you that it is very difficult and messy to produce this type of panel chart in Excel. The example R panel chart uses R’s a step chart format for one plot and R’s vertical line format for the other 2 plots. Several of R’s dynamic capabilities, not inherently available in Excel, are also used. No helper series are needed and the chart can easily be regenerated each month as new data is available.
Here’s The R Panel Chart
First, let’s take a look at the chart to see what’s so good about R charting.