Individual Submission Summary
Share...

Direct link:

Turning Excel Charts into Interactive Data Visualizations using AI

Thursday, November 5, 3:30 to 5:00pm, Property: Boston Marriott Copley Place, Floor: 4th Floor, Room: APPAM Booth (Grand Ballroom)

Abstract

Excel is still the tool that most analysts, researchers, and communicators build their charts. The results are usually static images pasted into reports and slide decks. Meanwhile, readers increasingly expect to hover, filter, and explore data on their own, and other researchers often want to get their hands on the data. Until recently, closing that gap meant learning JavaScript libraries such as D3 or Chart.js but generative AI tools have changed that. In this hands-on session, participants will learn a practical workflow for turning an Excel chart into an interactive, web-ready data visualization using AI assistants, without writing code from scratch. The session opens with a brief live demonstration. Starting from a standard Excel dataset, I’ll use Claude AI to generate an interactive HTML version with tooltips, filter, and annotations. Along the way, I'll show what the AI does well, where it stumbles, and why the human in the loop still matters. I’ll also demonstrate some additional projects and tools I’ve built using Claude, noting the things it does well and the things it sometimes misses. The hands-on portion forms the core of the session. Working individually or in small groups, participants will receive a sample dataset and use the AI tool of their choice to build an interactive version. A short “spot the error” exercise asks participants to find mistakes in the AI-generated chart, reinforcing the importance of verification and factchecking. We’ll close by sharing a few participant results, comparing the prompts that produced them, and discussing when interactivity genuinely helps readers and when a well-designed static chart is the better choice. By the end of the session, participants will be able to prepare Excel data and charts for AI-assisted conversion; write clear, specific prompts that produce usable interactive visualizations; evaluate AI-generated output for accuracy, clarity, and accessibility; and decide when interactivity adds value for their audience. Participants should bring a laptop with Excel and access to a generative AI tool. No programming experience is required.

Author