How to Create Cycle Plot Chart in Excel

Share Now

A cycle plot is a type of line graph that is useful for displaying cyclical patterns across time. Cycle plots were first created in 1978 by William Cleveland and his colleagues at Bell Labs. We published an article about them in 2008, written by Naomi Robbins, titled Introduction to Cycle Plots.


Cycle Plot Chart in Excel

Download: Cycle Plot Chart Workbook

Steps to create Cycle Plot Chart in Excel:

Step 1:
First we need to create the Line chart for Sales data and Average of Data
– Here we are creating line chart for quarterly sales data across years.
In Excel 2013 – Select Data > Insert Tab > Click Line Chart (Under Charts Group)

Cycle-Plot1Cycle Plot Chart in Excel 2

Step 2:
Now we have to insert gap between segments to draw separate line chart for each cycle.

Insert blank row after each segment.


And now chart leaving a gap between lines (Data and Average Lines).

Cycle-Plot4 in Cycle Plot Chart in Excel

Here is your cycle plot chart and now you can change the chart look by format chart elements to make it look kool 🙂

Share Now
November 15, 2019

0 responses on "How to Create Cycle Plot Chart in Excel"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Social Media

    facebook page EC Analytics Consulting   Linkedin Page EC Analytics Consulting   Youtube EC Analytics Consulting


    0124- 4601426


    EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED