The Shape of the Curve: Spot Seasonality Before It Spots You
Every business has a heartbeat. We show how to overlay your yearly data to spot the predictable dips and surges that look like crises but are actually rhythm.
The Panic in August
Come, sit by the screen. I want to show you a line chart that looks like a heart attack.
The line is climbing steadily in Q1 and Q2. The team is celebrating. We are geniuses. And then, July hits. The line stumbles. August arrives, and the line falls off a cliff. The slack channels go silent. The CEO calls an emergency meeting to “fix the funnel.”
But look closer. Let us load the previous two years of data.
Do you see the shape? In 2023, the cliff was there. In 2022, the cliff was there.
The cliff is not a failure of strategy. It is simply the month where your clients go to the beach.
The Noise: When we look at data sequentially—one long line from left to right—we lose the rhythm. We see the drop as a new event. We react to it emotionally. We try to “fix” August by spending more on ads, which is like trying to yell at the tide to stop it from going out.
The Pattern: Every business has a biological clock. There are harvest months, and there are winter months. If we ignore this shape, we are fighting nature.
The Overlay Technique
We must stop looking at the long tail of time. We need to stack time.
Open your spreadsheet. We are going to build a Seasonality Overlay. Create a table where the rows are “Months” (Jan-Dec) and the columns are “Years” (2022, 2023, 2024).
Now, plot this as a line chart with multiple series.
[TO EDITOR: Illustration needed. A Line Chart with three lines of different colors (Gray, Light Blue, Dark Blue). They all follow the exact same snake-like path—up in Spring, down in Summer, huge spike in Q4. Caption: “It’s Not a Crash, It’s August.”]
Suddenly, the “Crisis of August” disappears. Instead, you see the Echo. You see that every year, the curve bends the exact same way. The only difference is that this year, the curve is higher on the Y-axis. That is the growth. The dip is just the tax we pay to the calendar.
Adjusting the Lens
Now that we see the pattern, we can stop lying to ourselves.
We calculate a “Seasonality Index.” If August is historically 80% of the average month, then a $100k month in August is actually impressive—it is equivalent to a $125k month in October.
When we adjust for seasonality, we smooth the panic. We can tell the board: “Yes, revenue is down month-over-month, but we are beating the seasonal trend by 5%.”
That is the difference between a reactive manager and a Visual Investigator. One screams at the weather; the other brings an umbrella.
FAQs
My business is growing too fast to have seasonality, right?
Wrong. Even a rocket ship fights gravity. You have growth *plus* seasonality. You must separate them.
How many years of data do I need?
Three years is the magic number. One is a dot, two is a line, three is a pattern.
How do I visualize this?
Do not plot them end-to-end. Stack them. Overlay 2023, 2024, and 2025 on the same X-axis (Jan-Dec).