Designed an AI system that surfaces trends, anomalies, and comparisons the moment a chart is inserted in Excel. Increased chart retention by 15%, validated Copilot’s value for non-coders, and repositioned Excel as an analytical assistant—not just a calculation tool—with 65% positive sentiment.
Liked this project?
Let's talk about what we can build together.
Introduction
Charts don't create value — insights do. Yet Excel forced users to manually interpret every visualization. As Lead Designer for Copilot Chart Intelligence, I designed an AI-powered system that automatically surfaces key takeaways the moment a chart appears. This post-insert 'aha moment' increased chart retention by 15%, validated Copilot's value for non-coders, and fundamentally repositioned Excel as an analytical assistant, not just a calculation tool.
Results Overview
Higher Chart Retention
Positive Feedback Rate
Copilot Engagement Lift
Factual Accuracy
The Problem: Charts Without Context Are Decoration
What Users Were Telling Us
"The chart shows the data, but I still don't know what it means."
— NPS Feedback
"I spend more time writing bullet points about the chart than creating it."
— Enterprise User
"My manager asks 'so what?' and I have to explain manually."
— Analyst
Key Observations
“Charts should tell a story – ours don’t.” This succinct user insight underscored how Excel charts lacked narrative value
Many users deleted charts soon after insertion, signalling they didn’t find them usefull or attractive – an estimated 60% deletion rate for inserted charts.
On Excel Web, charting drew a disproportionate share of negative feedback (22% of all Excel Web frown feedback was chart-related), citing missing features and difficulty “getting charts to tell me anything”
💡
CORE INSIGHT: Users weren't struggling to make charts — they were struggling to extract meaning from them. Excel gave them the 'what' but never the 'so what?'
Why Competitors Were Winning
In our competitive analysis, tools like Tableau, Power BI, and AI-native platforms were delivering automatic insights:
Tableau: 'Explain Data' feature surfaced statistical anomalies
Google Sheets + Gemini: Proactive suggestions like 'This category is declining'
ChatGPT Data Analyst: Generated natural language summaries of uploaded CSVs
Napkin AI: Auto-generated visual explainers from text descriptions
CRITICAL GAP: Competitors understood that modern data viz isn't just rendering pixels — it's helping humans think. Excel was stuck in the old paradigm.
The Business Case for AI Insights
This wasn't just feature parity — it was strategic necessity:
The Opportunity
Why Chart Insights, Why Now: These competitive insights underscored that to stay relevant and delight users, Excel had to infuse intelligence directly into charting. It wasn’t enough to improve the UI or add new chart types; the next logical step was a Copilot-driven experience where the moment a user creates a chart, the software adds value by explaining the data.
| Metric | Value | Denominator | Meaning |
| 2% | 8M / 400M | Total Excel MAU | Overall market penetration |
| 16.5% | 4M / 24M | Copilot-enabled users | Chart usage among Copilot users |
| ~11% | 2.6M / 24M | Copilot-enabled users | Copilot usage among enabled users |
Among Copilot-enabled users, 16.5% create charts but only ~11% actively use Copilot features (November 2024 data). This 5.5pp activation gap represented a clear opportunity — users with Copilot access who chart frequently weren't leveraging AI features.
Competitors were turning charts into “visual narratives” – combining charts with insights and even action suggestions
JTBDs
Understanding what users are actually trying to accomplish when they create and analyze charts in Excel.
| When I... | Insert a chart to visualize quarterly revenue data across product lines |
| I want to... | Immediately understand what patterns, trends, and anomalies exist without manually calculating statistics or staring at the chart for 10 minutes |
| So I can... | Confidently present findings to my manager, make data-driven decisions faster, and avoid missing critical business insights |
| Without... | Spending 20+ minutes manually analyzing every data point, second-guessing my interpretation, or relying on my manager to spot issues I missed |
| When I... | Need to present analysis to stakeholders who don't have time to dig into raw data |
| I want to... | Have ready-made narrative bullets that explain what the chart shows in plain language, with the option to copy them directly into emails or presentations |
| So I can... | Save hours writing explanatory text, ensure I'm communicating the most important findings, and look like a data expert even if I'm not |
| Without... | Spending 30+ minutes writing bullet points, worrying I'm focusing on the wrong metrics, or having my manager ask 'what about X?' that I completely missed |
| When I... | Create a chart for a high-stakes presentation (board meeting, executive review) |
| I want to... | Get a second opinion from AI to confirm my interpretation is correct, or alert me to patterns I might have missed |
| So I can... | Present with confidence, avoid embarrassing mistakes, and discover insights that make me look smart rather than missing obvious trends |
| Without... | Asking my manager to double-check every chart, staying up late rechecking numbers, or getting called out in a meeting for missing something obvious |
| When I... | Work with data regularly but don't have formal analytics training |
| I want to... | See examples of how experienced analysts interpret data, so I can learn what questions to ask and what patterns matter |
| So I can... | Develop my analytical skills over time, become less dependent on others, and eventually spot these patterns myself |
| Without... | Taking a formal data analytics course, bothering my analyst colleagues with basic questions, or relying on trial-and-error that wastes time |
My Role: Designing Intelligence, Not Just Interfaces
MVP — Prove the Core Value
Show static insights on chart insertion to validate whether automatic, immediate analysis delivers value.
| Success criteria | 40% click rate achieved vs. 20% target |
| Validation | A/B test for chart retention, Copilot activation |
| Performance target | P95 <20s generation |
| Interaction | Click → popover → thumbs feedback → Ask Copilot |
| Constraints | Creator-only, no persistence, native charts only |
| Scope | Skittle button on chart insert (Web first), 1-3 insights, manual refresh |
Make It Interactive & Contextual
Enrich insights with responsiveness to chart edits and expand access to chart consumers.
| Responsive insights | Auto-update when chart type/data changes |
| On-demand access | Right-click any chart → Generate Insights |
| Persistent insights | Save as chart property, visible to collaborators |
| Enhanced interaction | Copy text, "Explain why" button, hide individual insights |
| Platform parity | Win32, Mac support, multi-chart scenarios |
| Edge cases: | Trendlines, empty charts, error recovery |
Deep AI Analysis & Storytelling
Transform insights into a conversational analytical assistant with cross-chart narratives and M365 integration.
| Conversational analysis | Embedded Copilot chat with context maintenance |
| Cross-chart insights | Multi-chart narratives and high-level summaries |
| Visual highlights | Link insight text to chart elements (hover to highlight) |
| M365 integration | Send to PowerPoint with auto-generated slides |
| Advanced analytics | Predictive trends, correlations, diagnostic analysis, benchmarking |
| Vision | Excel as AI-driven analysis platform with intelligent partnership |
The MVP : Version 1
If dismissed users can trigger back insights from right-click menu or through chart ribbon menu
Another version exploring the Copilot pane instead of on-canvas dialog
The Collision: When Reality Punched Back
We designed for <5s latency, got >30s reality. Next time: prototype with artificial delays from day one. Assume performance will be worse than promised.
I inserted the chart and just... waited. It felt broken. I thought Excel crashed.
Users clearly preferred on-canvas overlay, but technical and real estate constraints made it impossible in its original form. The skittle button preserved the contextual proximity users loved while solving latency and space problems.
Version 2: Introducing the Skittle
We also added a pop-over toast to highlight
Key Design Decisions & Trade-offs
Choice: Auto-trigger on insert (with easy dismiss)
Why: Testing showed users didn't know to ASK for insights. Making it proactive was key to discovery.
Choice: No auto-refresh on data changes
Why: Performance risk, user distraction, and testing showed users preferred control. They'll hit refresh when ready.
Choice: Floating panel anchored to chart
Why: Sidebars compete with other UI. Inline feels contextual, less like 'another feature' and more like 'the chart explaining itself'
Choice: Binary thumbs up/down, not 5-star scale
Why: Lower friction, higher response rate. We cared more about volume of feedback than granularity.
Impact & Results
📌
Critical feedback we addressed:
⭐
Key Learnings
Built for <5s latency, got >30s reality. Had to pivot mid-sprint.
Next time: Design for 10x slower than best case. Prototype with artificial delays (5s, 15s, 30s). Have backup pattern ready from day one.
Designed in isolation, learned about Design Recs conflict late.
Next time: Audit all features that trigger on same event. Test on 1366x768 screens from day one. Involve PM in multi-feature roadmap alignment earlier.
Defined metrics after design was done. Had to retrofit event tracking.
Next time: Create telemetry schema during wireframing. Every interaction state = logged event. Treat telemetry as a design deliverable.
Tested with clean datasets (5 columns, 100 rows), shipped to messy reality (500 columns, formulas, merged cells).
Next time: Start with messiest data first. Create 'data chaos test suite' for prompt validation. Design failure states as prominently as success states.
The Bigger Lesson
AI features succeed when they
✅ Solve a clear job-to-be-done: Not 'AI for AI's sake' but 'help me understand my data'
✅ Appear at the right moment: Context matters more than capability
✅ Build trust through accuracy: One wrong insight destroys 10 good ones
✅ Empower, don't replace: Users still own the analysis; AI just helps them see faster
The Newsletter
Conclusion
Chart Insights transformed Excel from a calculation tool into an analytical partner. Through three design iterations—from a failed auto-expanding panel to a low-discovery skittle button to a successful actionable toast pattern—we learned that AI features succeed when they respect user agency, manage latency transparently, and fit seamlessly into workflows. The result: 40% engagement, 15% chart retention lift, and a validated path forward for Copilot in Excel. Most importantly, we proved that constraints drive innovation and that designing for real-world conditions beats optimizing for perfect scenarios.
