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 Data Visualisation: Does Your Graph Actually WORK?
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.

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
FP&A Storytelling

The graph is the right way to present your FP&A information. The important question is:

What changes and additions to the graph will help your audience understand its central messages quickly and accurately? Will visual effects that “beautify” the graph help or hurt that objective?

Remember why you’re creating a graph in the first place: to enable your audience to grasp an important point quickly and effectively.  With that in mind, consider the following graphs, which I found when googling “U.S. trade balance for 2016”:

Each of these graphs was on the first page of Google hits, so they came from large websites with access to plenty of FP&A talent. Now look at each of these graphs and ask yourself questions ranging from the picky to the metaphysical, such as:

  • Can you quickly understand the graph is about?
  • Can you read the numbers and other print?
  • Do you have a good sense of the magnitude of the period-to-period differences?
  • Does the graph illustrate a clear trend or pattern? Does it tell a story?
  • The last of the four graphs makes the most extensive use of colors and other text effects.  Does all that make the graph easier or harder to read?

All in all, I was unimpressed. Almost every FP&A professional has at least one college degree, and yet so often we forget the fundamentals of clear communication. Here are just a few of the graphing principles you should always keep in mind:

  • The print should be large enough to read.
  • Include clear, correct titles and other explanatory information.
  • Use intelligent axis scaling, tick marks, gridlines, data labels, and other visual aids to enable readers to understand the numbers with the appropriate level of precision.
  • If the variable being graphed has a “natural zero,” the axis scale should include zero.
  • But make sure that the abovementioned “visual aids” don’t stand out more strongly than the data you’re trying to present. (Or, as Edward Tufte has put it, you want to maximize the data-ink ratio.)

That last point deserves special mention because today’s graphing software lets you really cut loose with visual effects. For example, do three-dimensional graphs – like the one below – really make information easier to understand, or do they just look glitzy?

Another example comes from a major stockbroker’s mobile app, showing the day’s movement of three major U.S. stock indices. Here’s what you might want to learn from this infographic (perhaps you’ll add one or two points of your own):

  • Is the market up or down today?
  • Is today’s market movement – whether up or down – large or small?
  • How is each index moving, compared to the other two?

Now, cover the bottom half of the image, and look only at the graph:

Were our questions answered? Well, the absence of a clearly marked zero line on the vertical axis scale makes it hard to tell whether the indices are above or below their previous day’s closes.  The choice of scaling that axis so that the graph lines fill the chart area from top to bottom makes it impossible to tell whether the market moves are large or small. And the use of non-intuitive distances between gridlines (0.18% on this one, rather than, say, 0.1% or 0.2%) contributes to both problems.  Lastly, there are more effective ways of helping the reader associate each graph line with that index’s name than the tiny legend at the bottom of the chart area.

Frankly, the most valuable information is the little table comprising the bottom half of the screen. In fact, all I learn from the graph is whether the market went up or down during the day. This image comes from a company that spends millions on customer communications; they can do better. As an FP&A professional, what are the stakes for you personally when you’re designing your reports?

In this blog, we focused primarily on was how hard it is to make graphs instantly understandable, and how often we fail to achieve that – a problem that dogs expensively-produced infographics and not just our day-to-day FP&A work. We barely focused on the things you should do. That’s a long and very detailed topic, and there are several excellent references. In addition to my own book, Painting with Numbers, I strongly recommend Storytelling with Data, by Cole Nussbaumer Knaflic; Show Me the Numbers, by Steven Few; and of course any of the several works by Edward Tufte.

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

Applying Analytics to Storytelling
February 11, 2019

According to Google's Chief Economist, Dr. Hal Varian, "The ability to take data—to be able to understand...

Read more
Richard-Reinderhoff-Republished-Article-Talks-Figures
Strategic Planning Is About ‘Talks & Figures’
April 4, 2023

The link to strategic planning becomes evident when FP&A is placed within this bigger picture. By...

Read more
A Good Sketch is Better Than a Long Speech – 5 Benefits of Data Visualisation Tools
September 19, 2017

“A good sketch is better than a long speech…” a quote often attributed to...

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