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
Visual FP&A: Is Graphing the Right Choice?
October 7, 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

FP&A Tags
Financial Planning and Analysis
Data Visualisation
FP&A Storytelling

In my last article, I listed four questions you should ask yourself, and the order you should ask them in, if you are an FP&A professional considering using data visualization to communicate your information. In this article, we address Question #1: Which is the most effective way to impart your key information – a table or a graph? 

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.

To consider this question, let’s actually start with a graph, one that will be familiar to anyone who has worked in FP&A. It shows P&L results of the Vaporware and Software Technologies Corporation (VASTCo), a fast-growing software company:

The layout is straightforward: major expense categories are in stacked columns, and revenue is graphed as a green line. The distance between the top of the expense column and the revenue line is VASTCo’s operating income. The design is clean and clear, and generally meets the standards prescribed for graphical clarity. Now, study it carefully – take as long as you want – then turn away from the screen and ask yourself the kind of questions a typical FP&A professional needs to address, such as:

  • Revenues are obviously increasing, but is the growth rate going up or down?
  • Operating profit (in $) is also clearly growing, but how about operating margin (i.e. as a % of revenues)? Gross margin?
  • All the operating expenses – Cost of goods sold, Sales & Marketing, R&D, G&A – are also increasing. But are they under control?

In fact, other than observing that many of the P&L numbers were growing rapidly, what did you learn from the graph? If the answer is “very little,” is that just because you’re not a “visual person”? I doubt it – in fact, sometimes it’s remarkable just how little graphs actually tell us. 
Now let’s take a look at the same information, this time in a table:

In roughly the same amount of space as the above graph, this table presents more data – the raw $$ figures, plus those raw $$ as a percentage of revenues, plus some year-over-year growth rates – and with greater precision than you could possibly get from viewing a graph. In fact, these metrics – or key indicators, or ratios, or whatever you want to call them – are often more effective than graphs and other data viz techniques for driving your points home.

To enhance readability and emphasize key data, this table uses boldface and indented text to highlight the most important rows, and uses Conditional Formatting to shade cells green (or red) to highlight expense and profit numbers that, as a percentage of revenues, improved (or worsened) by more than 2.0% compared to the previous year. Yes, tables can employ data visualization as well!

Graphs are an immensely powerful presentation tool. But there is a central truth: Graphs work best when you are trying to demonstrate a trend or a pattern. For almost all other purposes, consider tables instead. This use of graphs is illustrated by one of my all-time favorites, created by the late Hans Rosling for the Gapminder website:

Here, Rosling is showing a correlation – which, after all, is a type of pattern – between a country’s GDP per capita and the life expectation of its people. As slick a presentation as it is – visit the site to see some amazing interactive features – it’s fundamentally making a single, simple, uncomplicated message that’s ideally suited to data visualization.

(By the way, imagine the kinds of information this type of graph, called a bubble chart, could present. For example, a bank could compare each branch’s loan default rates to the average household income of its borrowers, with each branch’s data point sized in proportion to its loan portfolio.)

Ultimately, when considering how information should be presented, the only criterion any FP&A professional should consider is how well that information will be understood by his/her audience. It’s not about your skill using the software tools, or about how “pretty” the information is, nor even what some in your audience claim about their cognitive preferences. (e.g., “I’m a visual person.”) And the first, and perhaps the most important, question to ask yourself is whether your information really lends itself to data visualization.

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.

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

Related articles

FP&A Data Visualisation: Does Your Graph Actually WORK?
October 7, 2017

When the graph is the right way to present your FP&A information, several important questions should...

Read more
The Most Useful Graph Ever
March 13, 2018

Well-designed incentive compensation plans – especially sales commission plans – are an incredibly powerful way to...

Read more
The Most Useless Visualisation Ever
December 16, 2017

Let’s take a look at some of the most messed-up, incomprehensible recent examples of quantation. Not...

Read more
+

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 Amsterdam FP&A Board
The Face-to-Face Amsterdam FP&A Board Transforming FP&A Together: Human & AI Synergy

May 15, 2025

The Face-to-Face Milan FP&A Board
The Face-to-Face Milan FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)

May 20, 2025

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

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