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.

(Source: perceptualedge.com)

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 Plot2

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

Insert blank row after each segment.

Cycle-Plot3

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

Cycle-Plot4




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
August 15, 2015

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 *

    Tableau Training in Delhi

    All Rights Reserved. EC Analytics Consulting 2014 - 2019.

    NM 23, Sector 14, OLD DLF Colony - Gurgaon (Haryana) India. 9582876837 | Privacy Policy

    Drop us a Query

    Call Us: +91 8826547882

    Drop us a Query