Chart Pack: Q3 2024 Growth & Momentum Review

At a glance

• Total revenue rose 13.5% from Q1 to Q3, from $402,200 to $456,300. Growth picked up from 5.9% (Q1→Q2) to 7.1% (Q2→Q3).
• South is the fastest-growing region. Revenue rose 30.5% from Q1 to Q3 ($121,500 → $158,600), and South delivered 68.6% of the $54,100 total increase.
• North is still the largest region but has stalled. It brought in $187,900 in Q3 (41.2% of revenue), down 1.3% from Q2. South's gap to North shrank from $60,500 in Q1 to $29,300 in Q3.
• New customers rose and churn stayed flat. New customers grew from 142 to 161 (+13.4%) while churned customers stayed between 34 and 38 per quarter. Net adds rose from 106 to 127 (+19.8%).
• South led Q3 net customer adds with 51, nearly double its Q1 figure of 26.

Data summary

• Rows analyzed: 9 (3 quarters × 3 regions). There are no duplicates, no totals rows and no missing values.
• Time span: Q1 2024 to Q3 2024.
• Cleanup: None needed. The data was already clean and consistent.

Chart 1: South revenue grew 30.5% from Q1 to Q3, more than double West's 11.2%

• Chart type and why: A sorted column chart is the clearest way to compare one growth number across three regions.
• Chart:

xychart-beta
    title "Revenue growth Q1 to Q3 2024 (%)"
    x-axis ["South", "West", "North"]
    y-axis "Growth (%)" 0 --> 35
    bar [30.5, 11.2, 3.2]

• Chart-ready data:

• Caption: South grew revenue almost ten times faster than North over the period. Most of the company's momentum is coming from South.
• Alt text: Column chart showing Q1 to Q3 2024 revenue growth of 30.5% for South, 11.2% for West and 3.2% for North.
• Build it in Google Sheets:
  1. Paste the table into Sheets. Select both columns, including headers, then choose Insert → Chart.
  2. In Chart editor → Setup, choose Column chart. The rows are already sorted high to low; keep that order.
  3. Go to Customize → Series and set the color to navy #1F3A5F. Then use Format data point → Add to set the South bar to orange #F28C28.
  4. Tick Data labels under Series and set the number format to one decimal place with a % suffix.
  5. Under Chart & axis titles, set the vertical axis title to "Growth (%)". Delete the horizontal axis title because the region names speak for themselves.
  6. Under Gridlines and ticks, remove the minor gridlines and lighten the major ones. Keep the axis minimum at 0.
  7. Copy the chart and paste it into Slides. Choose Link to spreadsheet so it updates if the data changes.

Chart 2: South closed the gap on North, from $60,500 behind in Q1 to $29,300 behind in Q3

• Chart type and why: A line chart shows each region's trend over the three quarters and makes the narrowing gap easy to see.
• Chart: Mermaid does not draw a legend. The lines from top to bottom are North, South and West.

xychart-beta
    title "Revenue by region, 2024 (USD)"
    x-axis ["Q1 2024", "Q2 2024", "Q3 2024"]
    y-axis "Revenue (USD)" 0 --> 200000
    line [182000, 190400, 187900]
    line [121500, 134200, 158600]
    line [98700, 101300, 109800]

• Chart-ready data:

• Caption: South's line climbs the most steeply, rising 18.2% in Q3 alone, while North dipped 1.3% from Q2. South's share of total revenue rose from 30.2% in Q1 to 34.8% in Q3.
• Alt text: Line chart of quarterly 2024 revenue showing North flat around $182,000–$190,400, South rising from $121,500 to $158,600, and West rising from $98,700 to $109,800.
• Build it in Google Sheets:
  1. Paste the table and select all four columns, including headers. Choose Insert → Chart.
  2. In Setup, choose Line chart. Confirm that Quarter is the X-axis and keep the natural Q1→Q3 order.
  3. Under Customize → Series, set the colors:
     • South: orange #F28C28, with line thickness 3px.
     • North: navy #1F3A5F.
     • West: a light gray such as #A6A6A6. This is a suggested neutral, not a brand color.
  4. Turn on Data labels for the South series only. Use the currency format with no decimals.
  5. Set the vertical axis title to "Revenue (USD)" and the minimum to 0. Place the legend at the top or bottom.
  6. Remove the chart border and minor gridlines. Paste the chart into Slides with Link to spreadsheet.

Chart 3: Total revenue rose 13.5% from Q1 to Q3, reaching $456,300

• Chart type and why: A column chart in natural quarter order gives a simple, direct comparison of company totals.
• Chart:

xychart-beta
    title "Total revenue by quarter, 2024 (USD)"
    x-axis ["Q1 2024", "Q2 2024", "Q3 2024"]
    y-axis "Revenue (USD)" 0 --> 500000
    bar [402200, 425900, 456300]

• Chart-ready data:

• Caption: Revenue grew every quarter, adding $54,100 from Q1 to Q3. Growth sped up in Q3 (+7.1% vs +5.9% the quarter before).
• Alt text: Column chart of total 2024 revenue: $402,200 in Q1, $425,900 in Q2 and $456,300 in Q3.
• Build it in Google Sheets:
  1. Paste the table, select both columns, and choose Insert → Chart → Column chart.
  2. Keep the natu