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
Top Three Mistakes in FP&A Data Visualisation to Stop Making Today
June 23, 2021

By Monika Piekarska, Data Visualisation Expert at Bank for International Settlements – BIS

FP&A Tags
Data Visualisation
FP&A Skills
FP&A KPI

dataWhat is your data literacy level? Everybody agrees data visualisation is powerful. When you get ready to prepare your month-end close reporting, you realise:

  • You don't have time to think of the visual presentation.
  • You get lost in tons of styling functionalities.

Then you go for templates from the web or take default options set up in your Excel or any other BI tool. Very often, default options are not the visual best practices. 

This article will guide you through the most common and not-so-obvious data visualisation mistakes. Since cognitive psychology is the main factor responsible for how we perceive, decode and remember information, in this article, I will share the science-backed evidence of why these three mistakes are crucial and how FP&A professionals can improve their data visualisation skills. 

1. Keeping pie charts in your favourites

Circles are tempting. By nature, we love circular objects. Infinity, unity, symmetry and purity are attributes of beauty. Most of them we associate with circles, so pie charts and doughnut charts seem to be perfect. 

Why should you avoid pie charts?

It is hard to read numbers accurately from the pie chart. The human brain does not perceive easily 2D shapes. In other words, we find it difficult to estimate which area is bigger. See for yourself! Guess the percentage values of these graphs:

How accurate was your guess? According to one of the studies, most people fail this experiment. It’s a piece of ultimate evidence that pie charts are not the best data visualisation graph choice as we talk about FP&A. Even though you put numbers next to the pies, it takes a bit of time to skim the results. Your attention goes to reading figures instead of comparing the size of the pie parts. Data visualisation must visualise numbers. If your eyes focus on reading the numbers, that means that the chart is as effective as a text table. Your goal is to provide insights quickly, accurately and efficiently to digest. Pie charts, including many categories, are inappropriate for reporting. If you agree with this statement, remove the pie chart from your report right now.

How can you replace pie charts?

However, the human brain deals incredibly well with one-dimensional shapes like lines, where we decode only the length of the object. See the same data as a bar chart:

actual across regions​

Notice, how easily and quickly you see the distribution across regions and proceed with comparison. After looking a second, you might conclude West and East regions spend much more than the South and Central. Also, you might say South spends a bit more than Central. In the above pie chart, it would be impossible to find out this insight.

Of course, there’s one situation when pie charts are yummy and friendly graphs in the business. 

When can you use pie charts?

Use pie charts when you present only two categories with each other. When you have more than two categories, choose a different type of data visualisation. Length is the most effective visual attribute for data accuracy. The length makes it easy:

  • comparing slight differences
  • sorting the data points
  • perceiving proportions

pie chart​


2. Showing green and red colours on the same page

Did we exceed the target or not? The typical FP&A use case is to depict the data in green and red, indicating good or bad signs. Such a simple choice like the right colour might disrupt the accessibility of the information to everyone.

red and green chart​

Why should you avoid this?

According to an NIH study from 2016, 10% of men and 0.5% of women cannot differentiate between green and red. By uploading the above graph to the Color-Blindness.com website, we can see how colour-blind colleagues see this data visualisation: 

brown colours​

How can you solve this issue?

Test your colour palette whether it is colour-blindness friendly. Save your custom palette to shorten your colour choice when you prepare your next FP&A presentation. Download Color Oracle or go to Color-Blindness.com to validate the colours in your graphs. The perfect combination of colour blind friendly colours are:

  • Blue and orange
  • Blue and red
  • Dark blue and bright green

These colours are key to the accessibility of the same data to everyone. Let’s simulate the perspective of the same colour-blind person once the report is blue and orange. The results are excellent!

colour blind friendly graph​

3. A decorative picture in the upper left corner

Why does it matter?

This corner is super essential for you! In European culture, you read from left to right in the Z-pattern. Skimming the page goes in F-shape.

People lose attention a couple of seconds after interacting with a presentation or report. You miss crucial seconds of concentration for looking at things such as a company logo or a decorative pane. Instead, your goal is to give asap the answers on:

  • What data do I look at?
  • How are we performing now vs the previous period?
  • Have we reached the target?
  • What are the key drivers this month?

We look most intensively in the upper left corner, and we remember best this information.

An eye-tracking study from Tableau Software shows a piece of evidence that users focus their attention in the upper left corner and skim the page in the F-pattern.

Tableau​

Source: Tableau Software

What's more, the way of skimming the page changes when you add vivid, attention-driving colours. The red colour attracts attention the same way as a human silhouette. That's why I recommend using red and vivid colours consciously, only when you intend to warn your audience with the message.

Tableau​

Source: Tableau Software

How can FP&A leverage the upper left corner?

Notation and standardisation are crucial in FP&A reporting. The data-driven metrics need a proper explanation to get out their value of them quickly. Instead of decorative pictures, put a meaningful title for the presentation. In a subtitle, explain what kind of data you present: spend category, currency conversion, forecast version etc.

Then, put there the most important strategic KPI or visualisation in the upper left corner.

Conclusion

You don't need a diploma in graphic design. It is a matter of little tweaks that skyrocket your FP&A storytelling and FP&A presentation skills.

Data visualisation must engage your audience. Make the FP&A story memorable by choosing the right chart. Communicate numbers accurately. Everyone must interpret the definition of the data points the same way.

They're more than 3 data visualisation mistakes I encounter every day. However, improving these three areas will give you a giant leap into data literacy. To recap, here are three tips to keep best practices in FP&A data visualisation:

  • Choose bar charts over pie charts.
  • Use colour-blind-friendly colours (e.g. blue and orange).
  • Put the top priority message in the upper left corner.
The full text is available for registered users. Please register to view the rest of the article.
  • Log In
  • or
  • Register

jfcorona

June 24, 2021

Thank you for the article, is very useful.
  • Log in or register to post comments

Lindaxu

June 25, 2021

Interesting and useful, thank you for sharing this information.
  • Log in or register to post comments

duncanwil

July 6, 2021

I thought this page and its message was important, necessary and excellent. I created my own blog entry on this topic and linked back to this page.
  • Log in or register to post comments

Related articles

storytelling
Why Storytelling is a Powerful Force Within FP&A
May 6, 2021

The role of the finance leader is changing. Before long, your colleagues may see you more...

Read more
storytelling
Balancing Analytical Depth with High-Level Storytelling
April 21, 2021

Now, more than ever, the FP&A profession stands to propel itself forward as the premier business...

Read more
Data Visualization
FP&A Data Visualisation: Moving from Insight to Impact
April 8, 2021

On the 9th of March, Larysa Melnychuk hosted an inspiring webinar about FP&A Data Visualization: Moving...

Read more
Storytelling
Less Is More – FP&A Storytelling
August 25, 2020

Knowing your numbers is a good starting point for an FP&A professional. But it is also...

Read more
Data Visualisation: How Context Affects Visualisations?
January 22, 2020

University of Pennsylvania researchers report that the human retina processes data at approximately 10 million bits...

Read more
Data Visualisation and Storytelling in FP&A
January 14, 2020

The purpose of Financial Planning and Analysis is not to build perfect forecasts and financial solutions...

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