Microsoft Patents an AI Tool That Copies Chart Styles From a Reference Image
You've found the perfect chart in a report or slide deck, and now you have to spend 20 minutes manually recreating its style in your own spreadsheet. Microsoft is patenting a way to skip that entirely.
What Microsoft's chart-style copy feature actually does
A designer pastes a screenshot of a beautifully formatted bar chart into a spreadsheet tool. Within seconds, their own data is displayed in the exact same style: matching colors, fonts, and layout. That kind of instant visual matching is what this patent is pointing toward.
Microsoft's filing describes an AI system that looks at a reference chart (basically any chart image you hand it) and figures out all of its visual properties: colors, fonts, borders, axis styles, and so on. It then translates those properties into formatting instructions and applies them automatically to your existing chart, producing an editable result you can keep tweaking.
The key word is editable. The system isn't just pasting an image on top of your data. It converts the visual style of the reference into real, live chart formatting that you can adjust further. Think of it as "format painter" for charts, but powered by an AI that can actually read an image rather than requiring you to click the original.
… analyzing the reference-chart using a multi-modal visual model, wherein analyzing the reference-chart identifies one or more formatting elements, based on the one or more formatting elements, generating one or more edit commands; …
Translation: The system uses AI to scan a sample chart and figure out its design rules.
How the AI reads an image and writes formatting commands
The system works in three stages, all happening inside a spreadsheet application.
- Analyzing the reference chart: A multi-modal vision model (an AI that can process both images and text together) examines the reference chart image. It identifies discrete formatting elements: things like bar colors, legend placement, font sizes, gridline styles, and background fills.
- Generating edit commands: Rather than storing the style as a static image, the AI translates each identified formatting element into a structured edit command (think of these as precise instructions, like "set the bar color to hex #2E75B6" or "move the legend to the bottom"). These commands are machine-readable, not just visual notes.
- Applying to your chart: The system takes those edit commands and runs them against your original chart, the one containing your actual data. The output is a new, fully editable chart that looks like the reference but still uses your numbers and remains modifiable in the spreadsheet.
The claim covers the full pipeline: accessing the reference, analyzing it with the vision model, generating commands, and displaying the resulting formatted chart. The architecture is designed to work inside a spreadsheet engine, meaning the formatting changes are real spreadsheet operations, not image overlays.
… bridges the gap between static reference images and dynamic, editable charts by applying AI-driven insights and automation to streamline chart styling.
Translation: It turns a flat picture of a chart into a working spreadsheet graphic you can easily edit.
What this means for anyone who formats charts in Excel
If you spend any time in Excel or a similar tool, you know how tedious chart formatting is. Every axis label, every color swatch, every font choice is a separate manual click. A feature like this would let you hand the AI a chart from a colleague's report, a company template, or a published graph, and get your own chart styled to match in seconds.
Microsoft's steady investment in AI-assisted spreadsheet tools puts this alongside Copilot features already shipping in Microsoft 365. The practical payoff is time: for anyone who formats charts regularly, the hours currently spent on visual consistency could shrink to seconds. Whether this ships as a Copilot feature, a standalone Excel tool, or something else entirely is not settled by the patent itself.
This is the sixth Microsoft filing we've tracked in AI image and video since June, joining earlier work on cleaning up photos by content and matching exact colors.
The concrete payoff here is easy to describe: if this works well, you'd stop wasting time manually copying chart styles. That's a real, everyday frustration for anyone who works with data in spreadsheets, and solving it cleanly would be noticed immediately.
The harder question is accuracy. AI vision models can misread subtle visual details (is that bar slightly transparent, or just a lighter shade?), and a chart where the colors are almost right but not quite can look worse than one you formatted from scratch. The patent describes a system that generates editable output, so the user can correct mistakes, but the value depends heavily on how few corrections are needed in practice.
This filing is a sensible, focused application of AI to a tedious task most spreadsheet users actually hate. It doesn't try to do too much, which is usually a good sign for something that might actually ship.
There are more where this came from
We read every patent application Big Tech publishes and send you the ones worth knowing. Plain English, free, every week.
The drawings
13 drawing sheets from US 2026/0268070 A1 · click any drawing to enlarge
Want this weekly breakdown for a company we don't cover? Patentlyze Pro →