Skip to main content
Home
The Online Resource for Modern FP&A Professionals
Please register to receive the latest FP&A news, updates and tips Login

Main menu

  • Home
  • FP&A Insights
    • FP&A Trends Digest
    • FP&A Trends Research
    • FP&A Trends Insight Paper
    • FP&A Trends Survey
    • Short Videos
    • Our Contributors
  • FP&A Events
    • International FP&A Board
    • FP&A Trends Webinars
    • Digital FP&A Circles
  • AI/ML Committee
    • Introduction
    • Members
    • Resources
    • Meetings
  • FP&A Tools
    • FP&A Trends Maturity Model
  • About Us
    • Company Policy
    • Privacy Policy
    • Editorial Guidelines
    • Our Ambassadors
    • Our Sponsors & Partners
    • Contact Us
image
FP&A Professional, Are You Choosing the RIGHT Graph for Your Story?
October 23, 2017

By Randall Bolten, longtime Silicon Valley CFO, author of "Painting with Numbers: Presenting Financials and Other Numbers So People Will Understand You” and adjunct professor at U.C. Berkeley Extension.

RANDALL BOLTEN grew up in Washington, D.C., the son of a CIA intelligence officer and a history professor. He is passionate about the importance of presenting financials and other numerical information in a cogent and effective way, and in his current life is the author of Painting with Numbers: Presenting Financials and Other Numbers So People Will Understand You (John Wiley & Sons, 2012).

He is a seasoned financial executive, with many years directing the financial and other operations of high-technology companies. His experience includes nearly twenty years as a chief financial officer of software companies.

He has held the CFO position at public companies BroadVision and Phoenix Technologies, and at private companies including Arcot Systems, BioCAD, and Teknekron. Before his CFO positions, he held senior financial management positions at Oracle and Tandem Computers.

He received his AB from Princeton University, headed west to earn an MBA at Stanford University, and ended up staying in Silicon Valley. 

In addition to writing Painting with Numbers, he currently operates Lucidity, a consulting and executive coaching practice focused on organizing and presenting complex financial information. He divides his work time between Glenbrook, NV and Washington, DC, and maintains an office in Menlo Park, CA.

FP&A Tags
Financial Planning and Analysis
Data Visualisation

What is the best way to present the FP&A information graphically? Again, the answer is far from obvious; all too often, FP&A professionals give little or no thought to this important question.

Let’s  start with a typical FP&A report:

The viewer gets a good sense of total revenue growth, and the gap between the stacked expenses and the revenue line shows how profitability has evolved. Unfortunately, it’s not at all helpful if you want to know how the individual expense components have changed – not only are those graph elements too small to measure visually, they all (except for COGS) start in different vertical positions. So let’s try again:

Now we actually can see how each expense component has evolved, and the horizontal gridlines help us measure each element with some precision. But this graph has its own set of “unfortunatelys”:  In particular, we deleted the Revenues line, since including it would have caused the expense columns to be too small to measure visually (note the changed vertical axis scale). And while we can now see how each expense has grown over time, we’ve lost any sense of what that has meant for profitability. Sigh. So let’s instead look at the operating expense components as a percentage of revenues:

Again, we learn something: the height of the stacked columns gives us a clear sense of the operating margin (although correlating lower height with higher profit may be visually counterintuitive), and we do have some visual sense of how each expense component has changed over time – note the series lines, which give us some additional sense of whether each category’s share of expenses has increased or decreased. But every FP&A analyst worth his salt can come up with yet another set of “unfortunatelys”.

Perhaps by now, you’ve noticed something: Graphs are usually only useful for making one or two points. If you have more points to make, you need more graphs… or show the information in a table instead. This is a fundamental truth that every FP&A professional ignores at his/her peril.

Wait, though, we’re not quite finished with this topic. A particularly poor – but increasingly widely-used – choice is graphs that are based on area rather than on a single dimension (i.e., height or width). An example is a graph I found in the Washington Post, describing the disposition of Jared Kushner’s assets as he moved into his White House role as a presidential advisor:

Do you find this graph informative? Personally, I don’t – it’s visually extremely difficult to compare areas side-by-side, and the somewhat random arrangement of dots makes it hard to form conclusions about the separate asset classes. Here are two other ways of presenting the same information, which combined take up less space than the above graph:

I would be comfortable with either of the above choices – they both provide a good sense of how Kushner is disposing of various types of assets – and the table even includes a key indicator at the bottom that tells the whole story. Now, are you a graphic artist trying to make your newspaper look modern and artsy, or are you an FP&A professional trying to make an important point as clearly and succinctly as possible?

[By the way, a much more serious flaw in all three of the above presentations is that they present the number rather than the dollar amount of assets. Who cares how many bank accounts Kushner owns? And what if the two companies Kushner is keeping have a market value greater than all the rest of his assets combined? I would call this presentation not just meaningless, but possibly dishonest – except that we can’t tell whether it’s overstating or understating the share of assets Kushner is disposing of. The subject of honesty will come up again in a couple of weeks!]

There are so many ways to graph information, and many of them are not just labor-intensive, but cognitively ineffective – area charts, especially the particularly evil pie chart (more on that some other time!), frequently fall into that category. But even if you’ve chosen one of the more effective ways of graphing information, also remember that graphs work best when you’re trying to make a single, critically important point.  One of the highest arts, if you want to be an FP&A star, is choosing the chart type that makes that one point most effectively.

The article was first published in prevero Blog

RANDALL BOLTEN grew up in Washington, D.C., the son of a CIA intelligence officer and a history professor. He is passionate about the importance of presenting financials and other numerical information in a cogent and effective way, and in his current life is the author of Painting with Numbers: Presenting Financials and Other Numbers So People Will Understand You (John Wiley & Sons, 2012).

He is a seasoned financial executive, with many years directing the financial and other operations of high-technology companies. His experience includes nearly twenty years as a chief financial officer of software companies.

He has held the CFO position at public companies BroadVision and Phoenix Technologies, and at private companies including Arcot Systems, BioCAD, and Teknekron. Before his CFO positions, he held senior financial management positions at Oracle and Tandem Computers.

He received his AB from Princeton University, headed west to earn an MBA at Stanford University, and ended up staying in Silicon Valley. 

In addition to writing Painting with Numbers, he currently operates Lucidity, a consulting and executive coaching practice focused on organizing and presenting complex financial information. He divides his work time between Glenbrook, NV and Washington, DC, and maintains an office in Menlo Park, CA.

RANDALL BOLTEN grew up in Washington, D.C., the son of a CIA intelligence officer and a history professor. He is passionate about the importance of presenting financials and other numerical information in a cogent and effective way, and in his current life is the author of Painting with Numbers: Presenting Financials and Other Numbers So People Will Understand You (John Wiley & Sons, 2012).

He is a seasoned financial executive, with many years directing the financial and other operations of high-technology companies. His experience includes nearly twenty years as a chief financial officer of software companies.

He has held the CFO position at public companies BroadVision and Phoenix Technologies, and at private companies including Arcot Systems, BioCAD, and Teknekron. Before his CFO positions, he held senior financial management positions at Oracle and Tandem Computers.

He received his AB from Princeton University, headed west to earn an MBA at Stanford University, and ended up staying in Silicon Valley. 

In addition to writing Painting with Numbers, he currently operates Lucidity, a consulting and executive coaching practice focused on organizing and presenting complex financial information. He divides his work time between Glenbrook, NV and Washington, DC, and maintains an office in Menlo Park, CA.

The full text is available for registered users. Please register to view the rest of the article.
  • Log In
  • or
  • Register

Lindaxu

June 26, 2021

every new FP&A professional should ready this article at some stage, the earlier the better.
  • Log in or register to post comments
+

Subscribe to
FP&A Trends Digest

We will regularly update you on the latest trends and developments in FP&A. Take the opportunity to have articles written by finance thought leaders delivered directly to your inbox; watch compelling webinars; connect with like-minded professionals; and become a part of our global community.

Create new account

image

Event Calendar

Pagination

  • Previous
  • May 2025
  • Next
Su Mo Tu We Th Fr Sa
27
28
29
30
1
2
3
 
 
 
 
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Transforming FP&A Together: Human & AI Synergy
 
18
19
20
21
22
23
24
Moving from FP&A to Extended Planning and Analysis (xP&A)
 
Five Critical Roles for Building a World-Class FP&A Team
 
25
26
27
28
29
30
31
FP&A Business Partnering and AI: A New Era
 
All events for the year

Future Meetings

The Face-to-Face Frankfurt FP&A Board
The Face-to-Face Frankfurt FP&A Board Five Critical Roles for Building a World-Class FP&A Team

May 22, 2025

BPAI
The FP&A Trends Webinar FP&A Business Partnering and AI: A New Era

May 28, 2025

The Face-to-Face London FP&A Board: Data Management & Analytics: Unlocking FP&A Value
The Face-to-Face London FP&A Board Mastering Data in FP&A: Smarter Analytics, Better Decisions

June 5, 2025

FP&A Trends Webinar The Evolving Role of FP&A: From Number Cruncher to Strategic Advisor
The FP&A Trends Webinar Making FP&A Teams Fit for the Future

June 11, 2025

The Face-to-Face New York FP&A Board
The Face-to-Face New York FP&A Board From Insight to Impact: FP&A Business Partnering in Action

June 17, 2025

FP&A Trends Webinar Practical Steps for FP&A Analytical Transformation.
The FP&A Trends Webinar Unlocking FP&A Analytical Transformation

June 18, 2025

The FP&A Trends Webinar How AI is shaping the future of Financial Planning & Analysis (FP&A)
The FP&A Trends Webinar Transforming FP&A with AI: Maturity, Impact, and Future Roles

June 25, 2025

The Face-to-Face Sydney FP&A Board
The Face-to-Face Sydney FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

June 26, 2025

The Face-to-Face Singapore FP&A Board: Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
The Face-to-Face Singapore FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

July 8, 2025

AI/ML FP&A
AI/ML FP&A
Data and Analytics
Data & Analytics
FP&A Case Studies
FP&A Case Studies
FP&A Research
FP&A Research
General
General
Integrated FP&A
Integrated FP&A
People and Culture
People and Culture
Process
Process
Technology
Technology

Please register to receive the latest FP&A news, updates and tips.

info@fpa-trends.com​

              

Foot menu

  • FP&A Insights
  • FP&A Board
  • FP&A Videos

Footer countries

  • Amsterdam
  • Austin
  • Boston
  • Brisbane
  • Brussels
  • Chicago
  • Copenhagen
  • Dubai
  • Frankfurt
  • Geneva
  • Helsinki
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London (Circle)
  • Melbourne
  • Miami
  • Milan
  • Munich
  • New York
  • Paris
  • Perth
  • Riyadh
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

Copyright © 2025 fpa-trends.com. All rights reserved.

0