How to Visualize Monthly Recurring Revenue (MRR) in Google Slides Using a Stacked Bar Chart

If you run a subscription business, Monthly Recurring Revenue (MRR) isn't just a metric. It's the heartbeat of your company.

But when board meeting prep rolls around, dropping a massive aggregate number on a slide simply doesn't cut it. Your investors and leadership team want the story behind the number. They want to know where the growth is actually coming from. How much is expansion from existing customers? Are new sales driving the bus? Is churn quietly eating away at your margins?

To answer those questions in a single glance, you need the right visualization. And for SaaS revenue, the undisputed champion is the stacked bar chart.

Why a Stacked Bar Chart is Perfect for MRR

A standard line chart is great for showing your net MRR growth over time. But it hides the underlying mechanics of your business.

A stacked bar chart, on the other hand, unpacks everything. By stacking your revenue components on top of each other month by month, you get a visual representation of your "MRR movements."

A typical setup looks like this:

• New MRR: The foundation of your growth (usually a solid primary color).
• Expansion MRR: Upgrades from existing accounts (a lighter shade of that primary color).
• Reactivation MRR: Old customers coming back.
• Contraction MRR: Downgrades (plotted as negative values, usually orange or yellow).
• Churned MRR: Lost customers (plotted as negative values, bright red).

When you put these together, the net height of the bar tells you how much money you made, while the colored blocks tell you exactly how you made it.

The Problem with Native Google Slides

If you've ever tried building a clean, professional stacked bar chart using the native Google Slides tools, you already know the pain.

First, you have to jump over to Google Sheets. Then you wrestle with the chart editor to get your negative churn values to display correctly. You spend twenty minutes trying to fix the legend. Finally, you paste a linked chart into your slide—only to accidentally hit "Update" a week later and watch all your custom formatting randomly reset. Or worse, you just take a screenshot, leaving you with a blurry, uneditable image.

It’s a clunky, frustrating workflow.

The Better Way: Using ExtraChart

We built ExtraChart so you can create high-end, publication-quality visualizations without ever leaving your presentation. No tab switching. No broken spreadsheet links.

Here is exactly how to visualize your MRR using ExtraChart.

Step 1: Launch the Add-on

Open your presentation. Head up to the top menu and click Extensions -> ExtraChart -> Create & Edit Charts. The ExtraChart sidebar will slide open on the right.

Step 2: Select the Stacked Bar Chart

You'll see a categorized list of 20 different professional chart types. Scroll down to the Bar & Column section and click the Stacked Bar Chart icon.

Step 3: Drop in Your MRR Data

Clicking the icon opens the ExtraChart popup editor. Instead of bumping you out to Google Sheets, we give you a lightweight, built-in data editor right next to a real-time preview of your chart.

Set up your columns: Month, New MRR, Expansion, Contraction, and Churn. If you already have this data sitting in Excel or a CSV export from Stripe or ProfitWell, just copy it and paste it directly into the ExtraChart grid. The preview on the left will update instantly.

Step 4: Brand Your Chart

Click over to the Settings tab. This is where you make it look like a million bucks. You can use our Color Palette Manager to assign specific hex codes to your data series—maybe a deep green for New MRR and a stark red for Churn. You can also adjust the padding, clean up the gridlines, and change the font to match your company's branding (like Inter or Roboto).

Step 5: Insert and Update

When you're happy with how the preview looks, hit "Create."

ExtraChart will render your stacked bar chart as a crisp, high-resolution image right onto your active slide. No messy background data files cluttering your Google Drive.

Here is the best part: When next month rolls around and you need to add your new MRR data, you don't have to start over. Just click the chart image on your slide, re-open the ExtraChart add-on, and it will load up your exact data and settings. Add a new row for the current month, hit update, and you are done.

Ready to build better board decks?

Visualizing complex revenue data shouldn't take hours of formatting. By using a stacked bar chart, you give your team total clarity on business performance. And by using ExtraChart, you get your prep time back.

If you want to stop fighting with spreadsheets and start building better presentations, give ExtraChart a try on your next slide deck.