What's New in Spreadsheet Charting — Q3 2026 Roundup

The bottom line

What actually changed in Excel and Google Sheets charting in Q3 2026 — finance Skills, Python charts, Gemini, and what matters vs what's noise.

What’s New in Spreadsheet Charting — Q3 2026 Roundup

Something worth noticing happened this quarter, and most of the coverage buried it under feature counts. The headline updates to Excel and Google Sheets charting in Q3 2026 weren’t about new chart types. They were about who — or what — gets to build the chart, and whether you can trust the result. Both Microsoft and Google spent the quarter moving AI from “suggests a chart” to “constructs the chart, connects the data, and tracks who changed what.” That’s a governance story dressed up as a features story, and it’s the more important one.

Here’s what actually shipped, what it means, and what’s noise.

Microsoft’s big move: finance Skills for Copilot

The most consequential announcement of the quarter came on June 25, 2026, when Microsoft rolled out Copilot Finance Skills for Excel to Microsoft 365 Copilot subscribers. Brian Jones, VP of Microsoft’s Excel Product Group, laid it out in a blog post: teams can now define reusable “skills” — repeatable instructions for recurring tasks like building financial models, closing the books, updating monthly reports, and running variance analysis.

Why this matters for charts specifically: variance analysis and monthly reporting are chart-heavy work. A “skill” that runs variance analysis produces variance visuals — bridge charts, diverging bars, actual-vs-target columns — on a repeatable, governed basis rather than someone rebuilding them by hand every month. We’ve dug into the chart-relevant details separately in our finance Skills hands-on breakdown.

The part the excited coverage glossed over: this is enterprise-gated and phased. The skills require an E3 or E5 license with the Copilot add-on. Organizations in the Targeted Release program saw them first, with broader availability rolling through August. Pre-built skills and federated data connectors went generally available, but custom skills stayed in Insider preview into July, and partner-built skills were slated for later in Q3. One industry analyst’s assessment, quoted in the enterprise press, was blunt and probably right: the templates do roughly 80% of what a standard FP&A team needs out of the box, and the last 20% still needs human tweaking to fit each organization’s chart of accounts.

So: real, significant, and not the instant transformation the launch-day write-ups implied. That gap between announcement and reality is a recurring theme this quarter.

Live financial data, straight into the grid

Alongside the finance Skills, Microsoft added live data connectors to financial sources — Morningstar for investment research and portfolio analytics, PitchBook for private-market data, and S&P Global via Kensho’s structured retrieval. FactSet was still in preview at quarter’s start, expected to reach general availability in July.

For charting, the significance is straightforward: a chart is only as fresh as its data, and pulling live financial feeds directly into Excel means finance charts can update against current numbers rather than a stale copy-paste. Paired with the extended change tracking — Excel’s “Show Changes” now retains edit history for up to a year, well beyond the old 30-day window — the direction is clear. Microsoft is trying to make Excel charts auditable: fresh data in, and a full record of who changed what on the way to the visual.

Python charts kept spreading

The April 2026 capability that let Copilot run Python inside Edit with Copilot continued its phased rollout through Q3, reaching more channels and tenants. This is the feature that lets Copilot generate matplotlib and seaborn visuals — boxplots, violin plots, pairplots, network graphs — that native Excel simply can’t draw.

It remains the most powerful and most misunderstood charting feature in Excel, for reasons we cover in full in our Copilot + Python charts deep dive. The one-line version for this roundup: these are rendered images, not interactive charts, so they’re superb for statistical exploration and a poor choice for anything that needs to stay live or be clicked. If you’re only now getting access, learn that distinction before you rely on it.

A small but telling Excel-web change: editable chart labels

Quiet, but genuinely useful: Excel for the web gained the ability to edit data labels directly within charts. For years the web version lagged the desktop on chart formatting, and label editing was one of the daily frictions. It’s a minor feature that removes a real annoyance for the growing number of people whose IT departments provision Excel for the web by default. Not a headline — but the kind of change you actually feel.

Google’s counter-moves in Sheets

Google didn’t sit still. The through-line from earlier in 2026 carried into Q3: Gemini in Sheets, which hit a state-of-the-art 70.48% on the independent SpreadsheetBench benchmark back in March, continued rolling out its end-to-end creation feature — build a P&L dashboard, add scorecards and bar charts above existing data, all from a plain-English brief, with a plan-then-execute approval step that keeps a human in the loop.

The most concrete Q3 charting change, though, was defensive and aimed squarely at Microsoft. On July 1 (Rapid Release) and July 13 (Scheduled Release), Google shipped a fix so that Google Sheets correctly renders 3D bar charts that already exist in imported Excel files, by reading the <view3D> OOXML element that had previously been silently flattened to 2D. Note the limitation Google left in place: Sheets still can’t create a 3D bar chart from scratch — you have to author it in Excel and import it. And the fix is specific to 3D bar charts; 3D column, pie, line, and area charts weren’t confirmed as covered.

Read that in context and it’s not really a charting feature. It’s migration bait. Google spent Q2 at Cloud Next boasting that moving an organization off Microsoft 365 onto Workspace is now up to five times faster, and quietly fixing Excel-import fidelity is exactly what you do when your pitch is “switch to us, nothing will break.” The 3D bar chart fix is a chess move, not a gift to chart-makers.

What matters vs what’s noise

Strip away the launch-day enthusiasm and here’s the honest scorecard for the quarter.

Matters: The shift toward governed, auditable, AI-built charts. Finance Skills, live data connectors, and year-long change tracking together point at a future where a finance chart is regenerated by a repeatable skill, fed by live data, with a full audit trail. That’s a real change to how reporting works — if you’re on an enterprise license that gets it.

Matters, quietly: Editable chart labels in Excel web, and Python charts reaching more users. Small and large respectively, both genuinely useful, neither hyped.

Mostly noise: The migration-driven Sheets import fixes. Real if you’re moving platforms, irrelevant to most people’s daily charting.

The pattern underneath it all: Both vendors are competing on trust and automation, not on new chart types. Nobody shipped a genuinely new way to visualise data this quarter. They shipped new ways to have the machine build the old visuals, with governance bolted on. Whether that’s progress depends entirely on whether you’d rather draw the chart yourself or audit one the AI drew — which is the question the whole industry is quietly circling.

What to watch heading into Q4

A roundup is only useful if it tells you where to point your attention next. Three threads are worth tracking.

First, whether Microsoft’s finance Skills actually reach the mainstream or stay stuck in the enterprise tier. The whole model — reusable, governed, chart-producing automations — only changes how most people work if it escapes the E3/E5 license gate. If custom and partner-built skills arrive broadly and cheaply, the “AI regenerates your variance charts every month” future gets real for ordinary teams. If they stay locked behind expensive add-ons, it remains a large-enterprise story. Watch the licensing, not the demos.

Second, whether Google converts benchmark wins into migration wins. Gemini’s state-of-the-art SpreadsheetBench score and the steady drip of Excel-import fidelity fixes are clearly aimed at making a switch off Microsoft 365 feel safe. The open question is whether “our AI is measurably good and your files won’t break” is enough to move organizations that have decades of Excel muscle memory. The 3D bar chart fix was a small tell; watch for bigger fidelity moves.

Third, whether either vendor ships an actual new chart type rather than a new way to build the old ones. This quarter, nobody did. That’s not a criticism — the automation and governance work is genuinely more consequential than another chart type would be. But it’s a notable gap, and the vendor that pairs trustworthy AI construction with a genuinely new visualisation could reset the conversation.

For now, the takeaway holds: Q3 2026 was the quarter charting became about who builds the chart and whether you can audit it, not about what the chart can show. That’s a quieter revolution than a flashy new graph type — and probably a more important one.


This is the first edition of a quarterly roundup. For the tools driving most of this quarter’s change, start with our complete Copilot charts guide. All dates and product claims above are drawn from Microsoft’s and Google’s own announcements and contemporaneous enterprise reporting.

C2
fx
=VLOOKUP(A2, E:F, 2, FALSE)
Employee ID Name Department Salary
101 Alice Engineering $120,000
102 Bob Marketing $85,000
103 Charlie Sales $95,000