The Modern Finance Playbook is a newsletter for today's finance professionals brought to you by Paul Barnhurst and Ron Monteiro.
Share
Link Correction: Data Storytelling that drives action: ACE your next presentation
Published 2 months ago • 9 min read
Brain Teaser of the Week
See the solution at the end of the email
🧠 Brain Teaser:
A woman has four daughters, and each daughter has one brother. How many children does she have?
This Week's Sponsor
Inspirational Quote
“Storytelling is by far the most underrated skill when it comes to business.”
— Gary Vaynerchuk
Message from our Sponsor
The best finance leaders don’t manage AR. They manage cash.
Monk is the AI-native AR automation platform pairing best-in-class cash application with collection agents that follow up on invoices, resolve disputes, and handle AP portal submissions for you. White-glove integrations with NetSuite, Sage Intacct, QuickBooks, and every major ERP.
Customers like Kyle at Elate cut DSO >40% and get 26 hours back a month. Book a demo to see how.
Finance has a reputation for boring our audience with lots of numbers and financial jargon. I have unfortunately gone through more than my share of boring finance presentations and truthfully have given many of them myself.
That is why learning to master the art of data storytelling and influencing is one of the best things you can do for your career.
A great framework for organizing and delivering your presentations is ACE. ACE is the framework Ron and I use in our Best Practices FP&A Course, which you can learn about here. It stands for
Audience – Start with understanding and catering to your audience. Content – Build insight and visuals that support your key message. Execution– How you deliver the message matters. Your voice your body language, etc.
Let’s talk in a little more detail about all three of these
Audience
Know what they care about - A sales VP and a controller will look at the same number and think two different things.
Remember WIIFT (What Is In It for Them) - If your recommendation does not focus on what they need and the problems they have, you will get a polite nod but no action.
Feedback is a Gift - Ask for feedback afterward. Almost nobody does. It is the cheapest way to get better at this.
Content
BLUF Principle – Bottom Line up front.State the conclusion and the recommendation first, then support it. This is not a mystery novel.
Always include a call to action - Even if the action is to monitor and do nothing, say it out loud. A story without an ask is just a report.
Bring options - I use the 1:3:1 here, which is focus on one problem, bring 3 recommendations, and the recommended solution. It gives people something to react to instead of a yes-or-no vote.
Execution
Pause - Slow down and use the pause. Silence feels much longer to you than to the audience. Studies show that even if you speak fast, it is fine as long as you pause after each sentence. Breathing and silence are your friends.
Words Matter - Pick your words carefully when you challenge the business. "Your forecast is wrong" vs. "Help me understand this assumption" get very different responses, even though your goal is the same: to understand the forecast.
Practice - Becoming a great presenter takes practice. Use tools like PowerPoint's Rehearse feature and ask others for feedback.
If you are struggling with your presentations, use the ACE framework to help you focus the conversation and improve your execution. If you want help improving your storytelling skills, then consider joining our next Best Practices FP&A cohort.
Business Partner's Corner
You Have the Numbers. But Is Anyone Listening?
Have you ever spent hours preparing an analysis…
Checked every number.
Built the model.
Created the slides.
Rehearsed what you wanted to say.
Then you get into the meeting…
And five minutes in, someone is checking their phone.
Someone else is answering emails.
I have 240-month end meetings and several budget or forecast meetings under my belt and many felt that way.
Eventually someone asks:
“So…what are you recommending?” 😁
I've been there.
Early in my Finance career, I thought great analysis would speak for itself.
It doesn't.
Our stakeholders are overwhelmed.
Think about the people we present to.
They move from meeting to meeting.
Their inboxes are overflowing. They have competing priorities. And we're often presenting just one of the many issues they need to think about that day.
So, when Finance shows up with 20 slides, six charts and a wall of numbers, we shouldn't be surprised when we lose them.
Attention has become one of our scarcest resources.
Our job isn't simply to provide accurate information.
Our job is to make people care about the information.
And that's where storytelling becomes a Finance superpower.
Great Finance stories aren't fairy tales.
When Paul and I talk about storytelling in Finance, we're not suggesting you start your forecast presentation with:
"Once upon a time, gross margin was 42%..." 😂
Storytelling in Finance is much simpler.
It's about finding the story hiding inside the numbers.
What's changing?
What's surprising?
What's at risk?
Why should your stakeholder care?
And what needs to happen next?
A great data story connects data and insight with a clear call to action.
Think Audience First
One of the biggest mistakes we make is starting with:
“What do I want to present?”
Try replacing that with:
“What does my audience need to hear?”
Your CFO may want the headline and financial impact.
Your Sales leader may want to understand what's happening with customers.
Operations may want to know what's driving the cost issue.
Same analysis. Different audience. Different story.
That's why our ACE storytelling framework starts with Audience before Content and Execution.
Here's my challenge for you.
Before your next Finance presentation, don't start by opening PowerPoint.
Start with a blank piece of paper and answer:
If my audience remembers only ONE thing from my presentation, what do I want it to be?
Then build your story around that.
Remove anything that doesn't help tell that story.
You may find that your 20-slide presentation becomes 10.
And your 10 slides might become 5.
Less information. More attention. Better decisions.
We'll cover forecasting and budgeting, management reporting and visualization, world-class analytics, and AI, and one of my favourite areas — business partnering, storytelling and influencing. And importantly, we build cases and exercises into each module.
Because you don't become a better storyteller by listening to someone talk about storytelling.
You become better by doing it.
And in a world overflowing with data, dashboards, and AI-generated content, the FP&A professionals who can find the story, simplify it, and make people pay attention will be incredibly valuable.
Stay Out of Excel Hell
How to Build a Dynamic Max and Min Chart
One of my favorite charts to build is a column chart that dynamically shows you the best and worst values. In this chart, the $24K in October-25 is highlighted green, signifying the best month, and Aug-25 is highlighted red, signifying the worst-performing month.
This chart is what I call a max-and-min chart, and I am going to walk you through how to build it in Excel. This chart, along with several others, is covered in my Best Practices FP&A course that Ron and I are running in October. If you are interested in joining us, you can learn more about the course here.
Step 1: Lay out the Data
Start with your data; at a minimum, you will want the month and your values. For this example, I have three columns: Period, Month, and Gross Sales.
Once we have laid out the data, we will want to put the data in a table. This makes the dataset dynamic, so when we add new months, they automatically appear in the chart. To create a table, highlight the data and press Ctrl+T. Make sure to name your table something like Tbl_Sales
Step 2: Add the Max and Min Columns
Once we create the table, we need to add 2 new data series: one for Max sales and one for Min sales.
In the first column, we will create the Min sales first. For the Min sales column, we only want the row with the minimum sales to show a number; all other rows should display a #N/A. We will use a combination of three Excel formulas to do this. We use a simple IF statement combined with a MIN so that when the min is displayed, it shows that value, and if it is not true, we use the NA function to show a #N/A.
The MIN formula will be written like this in column E:
This formula uses table nomenclature, so you will see the table column names instead of the column and row position. The formula says that if the current row has the minimum gross sales value, return that row's gross sales; otherwise, display NA().
So, when the min is displayed it shows that value and if it is not true it shows a #N/A.
The MAX formula will be written like this in column F:
This formula is the same as the MIN formula, except we substitute MIN for MAX.
When we have finished adding the MAX and MIN formulas, our table will look like this.
We now have a dynamic table that, when we add new records, the row with the MAX and Min sales will automatically update, and all other rows will display #N/A, which will keep them from showing up in our graph.
Step 3: Insert the clustered column chart
Select C2:F14. That is Month, Gross Sales, Min Sales, and Max Sales. Leave Period out; it is there for sorting, not for the chart.
Go to Insert Column, Clustered Column. What you get will not look like the finished chart, and that is ok we will build that in the next step.
Step 4: Clean up the chart
Before we fix the series, we are going to do some housekeeping items to the chart. We should do the following
Remove gridlines from the chart
Remove the border around the chart
Remove the axis with the axis labels from the chart
Remove the legend from the chart
Expand the size of the chart so the months are horizontal, not diagonal
Add a Chart Title: 2025 Chocolate Sales
If you are unsure how to complete any of these tasks, you can ask AI to help you by describing what you want to do, and it will walk you through it. Your graph should look something like the image below. If you have different colored columns, do not worry about it; that is just because you have a different color setup than me.
Step 5: Create an overlap of your data series
Right-click on any bar in the series and choose Format Data Series
Set Series Overlap to 100% and Gap Width to 70%. Will look like this:
The 100% overlap is what makes this work. It puts all three series into the same slot for each month, so that the min and max series sit on top of the full series. Since the Max and Min have only one value, they show nothing in all other months but the month with the value. This allows us to then color the sales differently for the max and min series, which we will do in the next step.
The Gap width at 70% controls the space between the data/months. I like to use 70% for a thicker bar, but you can adjust it to any gap width you like.
Step 6: Color the three series and add the data labels
Lastly, click each of the three series and color them. We will do the following.
Click the Gross Sales series once to select the whole series, then set the fill to a light grey. This is the baseline; it should recede. Go ahead and set the outline to no outline
Click the Max Sales series and set the fill to green. Click the Min Sales series and set the fill to red. Set the outline to no outline.
Once you set the colors, click to add data labels only to the Gross Sales Series. You do not need them for the Max or Min Series, as the Gross Sales already has those numbers in its data series. Your final chart will look like:
Many of you are probably thinking, "I can just have AI build it," and you might, but understanding best-practice design principles and how to build charts that tell a story is still a necessary skill in FP&A and will help you get more out of AI. Join our next Best Practices FP&A Cohort to learn how to make your visuals more compelling with and without AI.
Joke of the Day
My Excel file has trust issues.
It keeps asking me to save every five seconds
Brain Teaser Answer
Answer: 5. The four daughters share the same brother.
This Week's Sponsor Inspirational Quote “Clear is Kind.” Brene Brown Brain Teaser of the Week See the solution at the end of the email Three people need to cross a river at night. They have one small boat that can carry a maximum of two people at a time. Alex can row across in 1 minute. Blake takes 2 minutes. Charlie takes 5 minutes. When two people cross together, they travel at the speed of the slower person. The boat cannot cross without someone rowing it back. What is the minimum time...
Inspirational Quote “The most important thing in communication is hearing what isn’t said.” - Peter Drucker Brain Teaser of the Week See the solution at the end of the email Three Finance colleagues go out for lunch. The bill comes to $30, so each person contributes $10. The waiter realizes the bill should have been $25 and returns $5. The colleagues each take back $1, and they give the remaining $2 to the waiter as a tip. So each person has now paid $9, for a total of $27. The waiter has the...
Hey Reader, "Your analysis was brilliant, but your presentation lacked." I will never forget my boss's words; they taught me the value of the last mile of analytics. I gave a presentation to my CFO that was a disaster, and it was because I did a poor job of presenting the solid analysis I had done. The last mile of analytics is the key to influencing the business, and a few bad data visualizations can often undo the whole presentation. On Wednesday, November 18, I'm running a free live...