Written by
Dennis Jiang
Published on
November 20, 2024
Picture this: you're buried in Excel, drowning in data, and wrestling with formulas and charts.
What if I told you that you could visualize your data, analyze trends, and create perfectly customized charts—just by having a conversation?
Meet Rosie, your new data visualization companion within Excel. Rosie has already made a name for herself by simplifying tasks, from writing complex formulas to breaking down financial models.
But now, Rosie is leveling up with a feature that makes data visualization effortless. With a simple chat, you can transform raw data into meaningful, beautifully styled charts—no Excel expertise required.
Let’s explore how Rosie’s new tools turn endless rows of Excel data into clear, actionable insights.
Rosie started as a guide to make Excel simpler, turning user requests into formulas, trends, and insights. But the real challenge is finding the best way to communicate insights from the data you have.
Creating charts in Excel can be a hassle—choosing the right type, fixing colors, resizing fonts, and tweaking layouts takes forever. Rosie changes all that. Just tell her what you need, and she’ll design, update, and style your charts like a pro.
I picked a Kaggle dataset on Customer Shopping Trends to show you how this works.
The dataset has 3,901 rows and 19 columns packed with insights into customer shopping behavior.
If you’re unsure where to begin, just ask Rosie.
Rosie breaks it down instantly, explaining the data—customer demographics, purchases, payment methods, and locations—in plain English. She suggests analyses like sales trends or behavioral insights and offers the best charts to help you visualize the data.
Armed with her guidance, you’re ready to explore the data visually without the hassle of manual chart-building.
Here’s where Rosie shines. Not only can she generate charts, but she also knows which type of chart best suits the data and your analytical goals.
Let’s say you ask Rosie to “show the distribution of purchases by category.” In an instant, Rosie creates a bar chart that reveals that clothing and accessories are the most popular categories, with other categories like footwear and outerwear trailing behind. If the colors don’t match your style, you can simply type, “Update the color to match the chart above,” and Rosie adjusts it instantly.
Rosie handles time-consuming formatting tweaks, so you don’t have to.
Do you need the font size increased on the axis labels? Just ask.
Do you want the gridlines removed for a cleaner look? Just ask.
If the x-axis labels overlap, you can say, “Make the labels vertical,” and Rosie will adjust them for better readability. It’s like having a design assistant ensuring everything looks polished and professional with minimal input from you.
The real magic of Rosie’s visualizations lies in the combination of depth and flexibility she offers. Once the basics are set up, you can keep asking questions and dive deeper into the data without missing a beat.
Let’s say you want to explore the relationship between gender, state, and purchases. Rosie provides exactly what you asked for.
Rosie’s new visualization feature is more than just a tool for creating attractive charts. It’s a fundamental shift in the way we interact with data in Excel.
By taking care of the technical aspects of visualization, Rosie frees you up to focus on what matters: discovering insights, exploring patterns, and making data-driven decisions. With Rosie, you can go from raw data to polished, presentation-ready visuals without leaving your spreadsheet or breaking your workflow.
Whether you’re a data novice or a seasoned analyst, Rosie makes visualization accessible. You don’t need to memorize Excel’s menu options, master formatting tricks, or know which chart type best suits each analysis. Just ask, and Rosie will guide you there, transforming your Excel experience from a chore into a conversation.
Rosie isn’t just a tool; she’s a companion for anyone working in Excel, turning rows of data into stories that inform, persuade, and drive decisions. Her new visualization capabilities make it possible to go from data confusion to clarity in just a few steps, eliminating the barriers that keep so many people from fully leveraging their data.
So why not give Rosie’s visualization feature a try? Next time you’re buried in a spreadsheet, don’t struggle alone. Just ask Rosie how she can help.
Click here to try Rosie out yourself with our interactive demo
Thanks for reading!
Dennis Jiang
Cofounder and CEO