One of the great things about the new One Chart at a Time video series that I didn’t foresee, was all the great conversations I’m having about different chart types!
Two primary things came out of last week’s video from Kennedy Elliott about the cycle plot. First, Naomi Robbins shared the original paper where the cycle plot was introduced, which I hadn’t seen before. In William S. Cleveland & Irma J. Terpenning’s Graphical Methods for Seasonal Adjustment (1982) paper, they focus on the importance of seasonal adjustments in various data series and how graphs and charts should be a routine part of the process of seasonally adjusting data.
Second, Michael Brown commented that he needs to figure out how to create the cycle plot in Excel.
I definitely need to figure out how to create this cycle graph in Excel.
— Michael Brown (@Michael54289459) February 5, 2021
I’m pretty sure I have made cycle plots in Excel in the past, but couldn’t find my earlier files, so I created one based on a cycle plot Kennedy created when she was at the Washington Post in 2015 (and that she discusses in her video). I grabbed monthly sea ice extent data from the National Snow and Ice Data Center and created this version with just three data series.
Now, instead of creating a long, step-by-step blog post with screenshots and descriptions, I thought I’d try my hand at doing a video walk-through, which you can watch below or over at my YouTube channel.
You can also download my Excel file where I’ve inserted comments into the header cells so you can see how each series is plotted. It’s a fairly simple graph to create, so I hope this approach will be sufficient.
I haven’t created a lot of step-by-step video tutorials, but if you find it useful, please let me know in the comment section below. If you’d like to learn more advanced data visualization in Excel, check out my ebook.