How to Make an MRR Chart

If you run a subscription business, monthly recurring revenue is the number you live by, and almost certainly the number you visualize worst. The usual MRR chart is a single line creeping up and to the right, which looks reassuring and tells you almost nothing. It hides the only thing about MRR that actually matters: that the headline number is the net result of four very different forces pulling in opposite directions, and a line going up can hide a churn problem that is quietly getting worse underneath it.

A good MRR chart does not just show that recurring revenue grew. It shows how it grew, how much new business you added, how much existing customers expanded, and how much you lost to contraction and churn, because those four numbers are the difference between healthy growth and growth you are renting on borrowed time.

This is a guide to tracking and visualizing MRR so the chart earns its place in a board deck or an investor update. I will spend less time on "click here to draw a line" and more on the part that matters: understanding MRR as movement, calculating the components correctly, and choosing the chart, animated, so the people watching can see the health of the business and not just its size.

What an MRR chart should actually show
The four components of MRR movement
Step 1: Calculate your MRR components
Step 2: Pick the chart that matches the question
Step 3: Choose the time frame and what to label
Step 4: Build it and export the animated version
The mistakes that make an MRR chart misleading
A few MRR charts worth copying
The two-minute version

What an MRR chart should actually show

Monthly recurring revenue is the predictable revenue you can expect every month from active subscriptions, normalized to a monthly figure. An MRR chart plots how that number changes over time, but the useful version answers a sharper question than "is it growing?" It answers "is the growth healthy?"

Those are not the same question. Two companies can both show MRR rising from $85K to $178K over a year, and have completely different stories underneath: one adding lots of new customers while barely losing any, the other masking heavy churn with even heavier sales spend. The top-line number looks identical. The health could not be more different. The job of a real MRR chart is to surface that difference, which is why the best ones show movement and composition, not just a single climbing line.

So before you build, decide which question you are answering. "How big is our recurring revenue and is it climbing?" is a trend chart. "Is our growth healthy, and what is driving it?" is a movement chart. The second is almost always the more valuable, and the more impressive, thing to show.

The four components of MRR movement

Every change in MRR from one month to the next is the sum of four forces. Understanding them is the whole game, because a proper MRR chart is built on these, not on the raw total.

New MRR. Recurring revenue added from brand-new customers this month. The engine of top-line growth.
Expansion MRR. Additional recurring revenue from existing customers upgrading, adding seats, or buying more. Often the cheapest and healthiest growth you have.
Contraction MRR. Recurring revenue lost from existing customers downgrading or removing seats while staying customers. A quiet leak that a single line chart completely hides.
Churned MRR. Recurring revenue lost from customers who cancelled entirely. The force that determines whether your growth is durable.

From these you get the two numbers that matter most. Net new MRR is new plus expansion minus contraction minus churn, the actual change in your recurring revenue this month. And gross vs net tells the health story: if your gross additions are large but net new is small, churn and contraction are eating your growth, and that is exactly what an MRR chart should make visible.

Step 1: Calculate your MRR components

Get the inputs right before you think about design, because an MRR chart built on sloppy components will mislead confidently.

Normalize everything to a monthly figure. Annual plans must be divided across the twelve months they cover, not booked as a spike in the month they were paid. An MRR chart that jumps every time an annual contract lands is measuring cash, not recurring revenue, and the two tell different stories.

Separate the four movements explicitly. For each month, tally new, expansion, contraction, and churned MRR separately. This is the step most teams skip, and it is the step that makes the chart worth building. If your billing system does not break these out, the components are still recoverable from subscription changes: a new subscription is new MRR, an upgrade is expansion, a downgrade is contraction, a cancellation is churn.

Calculate net new MRR. For each month: net new equals new plus expansion minus contraction minus churn. Suppose a month brings $24K new and $11K expansion, against $5K contraction and $8K churn, net new MRR is 24 + 11 − 5 − 8, or $22K added that month. That single figure, and its trend, is the heartbeat of the business.

Derive your retention story. Two ratios fall out of the components and belong near any serious MRR chart: gross revenue retention (how much recurring revenue you keep before expansion) and net revenue retention (how much you keep after expansion). NRR above 100% means your existing customers grow faster than they churn, the holy grail, and it is worth surfacing because it is the number investors look for first.

Step 2: Pick the chart that matches the question

The right MRR chart follows from the exact thing you are trying to show. Here is the mapping.

"Our recurring revenue is climbing." Use a line chart or, for more visual weight, an area chart. Plot total MRR across twelve months and let the rising slope tell the trend. This is the simplest MRR chart and the right one when the audience just needs the trajectory. A dedicated MRR chart generator is set up for exactly this.
"Here is what drove the change this period." Use a waterfall chart to bridge from last month's MRR to this month's, stepping up with new and expansion, down with contraction and churn, and landing on the new total. This is the single most articulate way to show MRR movement, and it is the chart most teams are missing.
"How does our growth break down over time?" Use a stacked bar chart with new and expansion as positive bars and contraction and churn as negative bars each month. This MRR-movement chart shows at a glance whether your growth is healthy or propped up, because the churn sitting below the line is impossible to ignore.
"We crossed a milestone." Use an animated number counter when the story is one figure, ARR crossing $1M, MRR passing $100K, and let the number own the frame.

For the audiences that care most, there are tailored starting points: an investor update chart for the monthly note to backers, and QBR charts for the quarterly review. The discipline is the same as ever, pick the one chart that answers your exact question and resist cramming all four components and the total onto a single canvas.

Step 3: Choose the time frame and what to label

The window and the labels decide whether the chart reads instantly or makes people work.

Show enough months to make the trend real. Twelve months is the standard for an MRR chart, long enough to reveal a genuine trend and any seasonality, short enough to stay legible. For a movement chart broken into components, six to twelve months keeps the bars readable; beyond that they crowd.

Pick the comparison that tells the truth. Month-over-month is right for the recent trajectory, but it is noisy, one big annual deal or one lumpy month can distort the picture. For the headline health number, year-over-year MRR or trailing-twelve-month growth is steadier and harder to game.

Label the number that is the story. On a trend chart, label the latest MRR, because that is the headline. On a movement chart, make net new MRR the figure that stands out, with the components supporting it. And if your net revenue retention is above 100%, put it on the chart in words, it is the most important single number an investor will look for, and it should not be buried.

Step 4: Build it and export the animated version

With the components calculated and the chart chosen, building is fast. The workflow:

Open the MRR chart generator and enter your monthly figures, total MRR for a trend chart, or the four components for a movement chart.
Choose the chart shape from Step 2, line or area for the climb, waterfall or stacked bar for the movement, and add a clear title and the time window.
Pick a theme and let the preview animate as the line draws itself or the bars build month by month, so you see the story before you commit.
Export, choosing the format by destination.

The destination decides the format, and the animated export is what separates your MRR chart from the flat line everyone else screenshots:

A board deck or investor update? A clean PNG works if it is read statically, but an MP4 that builds the MRR month by month as you present lands the growth far more powerfully. This is the natural home for an animated investor update chart.
A social feed (LinkedIn, X)? A native MP4 video, square or portrait, three to six seconds, loops while people read. The animated LinkedIn guide covers the specifics.
A quick share in Slack or email? A GIF loops automatically.
A dashboard or page? An SVG stays crisp at any size.

A self-building MRR chart does something a static one cannot: it lets the audience watch the recurring revenue accumulate, which is exactly the feeling of compounding growth you want a subscription business to convey, and it now costs nothing extra to produce.

The mistakes that make an MRR chart misleading

Most weak MRR charts are not wrong about the total; they hide the things that matter underneath it.

The single-line cover-up. Showing only total MRR climbing, which can mask worsening churn entirely. If growth is your story, show net new MRR or the components, not just the top line.
Booking annual deals as spikes. Treating an annual contract as one month of revenue instead of normalizing it across twelve. This is measuring cash, not MRR, and it makes the chart lurch.
Ignoring contraction. Tracking churn but not downgrades. Contraction is a real leak, and a chart that omits it overstates retention.
Mixing MRR and ARR on one axis. Putting a monthly figure and an annualized one on the same chart confuses the reader about scale. Pick one and label it clearly.
Hiding the churn below the line. Designing a movement chart so the negative components are downplayed. The losses are half the story; show them as plainly as the gains.
A static export when the story is momentum. Sending a frozen line for the most compounding number your business has. If it is building, let it build on screen.

A few MRR charts worth copying

Steal these formats and drop in your own numbers.

The MRR growth climb

The simplest and most common. Twelve months of total MRR as a line or area chart that draws itself from left to right, $85K rising to $178K across the year, with the latest month labelled. The filled area makes the number feel substantial and the rising slope does the persuading. Right when the audience needs the trajectory and nothing more, and quick to build in the MRR chart generator.

The MRR movement waterfall

The chart most teams are missing. Start at last month's MRR, step up with new and expansion, down with contraction and churn, and land on the new total, animating each step in turn. It turns "we grew $22K this month" into a visible story of cause and effect, and it is exactly what belongs in an investor update or a QBR deck where people want to understand the engine, not just the output.

The components stacked bar

When you want the health of the growth visible at a glance, plot each month as a stacked bar, new and expansion above the line, contraction and churn below it, with net new MRR as the visible result. Animate the months building in sequence and any audience can see immediately whether your growth is durable or propped up. This is the single most honest MRR chart you can build.

The milestone counter

Sometimes the story is one number, MRR crossing $100K, ARR passing $1M. An animated number counter that ticks up to the figure gives the milestone the weight a static label never could. Pair it with a one-line caption naming the moment and the decision that drove it.

The two-minute version

You do not need a finance team or a motion designer for any of this. The whole method:

Treat MRR as movement, not a single number, normalize to monthly, and separate new, expansion, contraction, and churn.
Calculate net new MRR (new + expansion − contraction − churn); it is the heartbeat of the business.
Pick the chart that answers your question, line or area for the climb, waterfall or stacked bar for the movement, counter for a milestone.
Show twelve months, label the latest MRR or net new, and surface net revenue retention if it is above 100%.
Build it, then export the animated version, an MP4 for board decks and feeds, a GIF for quick shares.
Let the growth build on screen, so the audience sees the health of the business, not just its size.

Your MRR is the most important number you have, and a single climbing line is the least it can tell you. Break it into its parts, show the movement, and let the chart prove the growth is real, one month at a time.