SWTCH by Pigment
Three days of predictions, insights, and advice from leaders in finance, sales, HR, supply chain and more
Register now here
SWTCH by Pigment
Three days of predictions, insights, and advice from leaders in finance, sales, HR, supply chain and more
Register now here
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.
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:
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:
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):
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.
According to Google's Chief Economist, Dr. Hal Varian, "The ability to take data—to be able to understand...
The link to strategic planning becomes evident when FP&A is placed within this bigger picture. By...
“A good sketch is better than a long speech…” a quote often attributed to...
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.