|
Hello hello! So, you’ve finally got your models built, and your numbers are accurate. But now you are dreading the 3 hours you are about to spend in PowerPoint, trying to make a waterfall chart that doesn't look like a tax form. And the crazy thing? By the time you've finished the visuals, the conversation has changed already. One person wants to see a different scenario. Another wants it broken down by region. So, you end up back in Excel, rebuilding everything. But what if I told you there's a way to create board-ready financial visuals in 10 minutes instead of 3 hours? And I'm not talking about templates or fancy BI tools that take weeks to set up. Today, I'm going to show you exactly how to do this. You don’t need to be a data visualization expert, and you don’t need to spend thousands on new software. All you need is 30 minutes this week. It will change how you present financial data forever.
|
The tool I'm going to show you is ChatGPT Canvas. And it's built specifically for this type of workflow.
You don't export the data and import it somewhere else. And, you don't need to switch between five different applications.
Instead, you build the model and the visuals in the same place, so when something changes, everything updates together.
This is not about making prettier charts. It's about reducing the 3-hour gap between ‘model complete’ and ‘presentation ready.’
And once you see how this works, you'll never go back to the old way.
Now, how do you do this?
To do this in ChatGPT, enable Canvas.
Canvas is a side-by-side workspace where you and the model co-create charts, tables, and slides in one place.
You don’t need to context-switch between your AI chat and your documents.
Step 1: Open Canvas
Type “/canvas” (or select if from your menu by clicking ‘+’).
Step 2: Provide Data
Paste a small table or upload a CSV/XLSX document. State your units (e.g currency; thousands/millions) and your time granularity (e.g Month/Quarter/Year).
If you have created a financial model in the chat already, the AI will use the data you have uploaded previously and generate the visuals based on that.
Step 3: Ask for the visual
Specify your chart type and chart dimensions.
Example prompt:
“Build a variance waterfall for 2025 vs 2024 from this table. Bars: Price, Volume, Mix, FX, Cost. Show both $ and pp impact. Add labels and a total column.”
Step 4: Refine
Request this like, axis labels, rounding, color-blind-safe colours, and annotations (e.g., “flag if the margin is < 20%”).
Step 5: Export
Copy the chart image into your slides or brief.
Pro Tip - Keep the data and the prompt under the chart for your audit trail.
Here's a short demo where I used ChatGPT Canvas to generate a dynamic presentation in html (the language used to create websites):
Prompt (copy/paste)
As a result of all of this, you will have no more financial presentations that are overwhelming data dumps that your colleagues struggle to understand.
Instead, you can now transform your data into clear, dynamic, and persuasive visual stories.
Time to let your creativity shine.
Join 270,000+ Professionals and receive the best insights about Finance & AI. More than 1 million people follow me on social media. Join us today and get 5 goodies from me!
Sponsored by Agicap Want to learn how to become an AI CFO? Join our FREE masterclass where I'll show you how to go from a traditional CFO to an AI CFO with super practical use cases you can start using straight away. Don't miss this 60 minute free masterclass with me. Spaces are limited so click the link below now to reserve your place. Reserve Your FREE Masterclass Seat Here Bonjour ;) Let me ask you this. How many times this week did you ask ChatGPT something, get back a response, and then...
Sponsored by SAP Staying up to date with SAP was always a big advantage for me in my career. And learning how finance teams are using AI and data to lead decision making will put you ahead. To make sure you don’t miss out on expert insights you can use in your work and to advance your career. Join SAP’s finance webinar series now by clicking the button below: Reserve Your FREE Space Here Hello hello, People ask me all the time this: “Nicolas, how do we keep our data safe using AI?” And, you...
Sponsored by SAP Staying up to date with SAP was always a big advantage for me in my career. And learning how finance teams are using AI and data to lead decision making will put you ahead. To make sure you don’t miss out on expert insights you can use in your work and to advance your career. Join SAP’s finance webinar series now by clicking the button below: Reserve your FREE spot here Hello hello! Tell me, do you spend a lot of time reviewing the work of your team, because you’re worried AI...