Report visuals don’t have to suck

Lots of reports have boring, ugly visuals. Or, even worse, visuals which are really, really hard to understand. The reports by CREG, the Belgian Federal Commission for Electricity and Gas Regulation, are completely different. For example, just browsing through the Monitoring Report — their yearly study on the functioning and price evolution of the Belgian wholesale electricity market — you can immediately see that it’s full of really thought-through visuals and graphs. There are three key principles they apply to bring their visuals to the next level.

Principle 1: add helpful annotations

Sometimes it’s in the small things, like adding a simple arrow to show that the yellow area is equal to the gray area between the grid load and the total load:

The total load and grid load in these curves have very strong seasonal patterns, making it hard to spot whether the delta between them also has seasonal patterns or not. Duplicating that delta at the bottom of the graph — nicely aligned with the horizontal axis — is the best way of making such patterns visual. In this case, there is some seasonality (the delta is slightly lower in winter), but much less pronounced than the seasonal patterns of the loads.

Principle 2: use small multiples to untangle complicated stories

When charts feel complicated, it’s often because they try to explain to many things at once. Different key stories in the data are fighting for our attention. Rather than just eliminating information to make a chart simpler, a helpful technique is to break it up into multiple smaller copies, each of which tells a single part of the story: a ‘small multiples’ approach.

The visual above shows the evolutions for four different countries over a 10-year time period in a small multiples arrangement. Comparing the exact values for the different countries side-by-side is a bit harder, because the bars are a bit further apart from each other than in a traditional clustered bar chart. But comparing the patterns between countries is now easy to do, and that’s the main objective of this chart — to show how different the electricity flow is among Belgium’s different borders.

Principle 3: don’t be afraid to use less common chart types

Not everything has to be a bar, line or pie chart. There are 100+ chart types available to us (if you want an extensive overview, you could check out the Data Viz Project or Data Visualisation Catalogue). Different chart types of course have similar things they can do, but each chart type does have its own strengths and weaknesses when it comes to highlighting certain aspects of your story. If you have an important key message to share, it’s worth considering a few different chart types and choosing the one that shows your message the most clearly.

In the CREG report, you will find bump charts, variable width bar charts (or Marimekko charts if you want to sound fancy), heatmaps, slopegraphs, waterfall charts, and ridgeline plots sprinkled in between the more traditional line and scatter plots. These more exotic charts are added on purpose, with a clear goal in mind, not just to make the report a little bit more fancy (although that is also an effect of chart variety: less boring reports).

Benefits of using better charts

The result of all of this? A 150-page report that doesn’t feel like a chore to read. There is variety, and everything is well explained. Thanks to the clear titles, subtitles and annotations every visual is its own self-contained mini-story — it’s not always necessary to read all the text before and after the figure to understand what’s going on. And most important of all: the graphs are clear and transparent. CREG gets its message across flawlessly, without being hampered by chart clutter, noise, or unnecessary complications. A clear, correct ánd beautiful presentation of the information — that’s what we should all strive for!

Disclaimer

I was (unfortunately!) not involved in the creation of these beautiful graphs. All visuals were created by Senior CREG Advisor Nico Schoutteet. You can read the report on the CREG website.

Read more:

thumbnail for video 06 - making a data visual noise-free

Making a data visual noise-free

Removing noise from a data visual is not only about taking things away such as gridlines, axes or legends. That’s just one part of it, which we could call removing physical noise. Improving the signal-to-noise ratio is often also about adding little things that help our audience better understand the visual. We are helping them by removing mental noise, or mental barriers.

Read More

Three tips to create powerful charts in Excel

Creating charts in Excel can be a very powerful tool for making sense of complex data sets, and for visualizing them. But the default options are not always the most pretty or effective ones. Here are our top three tips to create better Excel charts.

Read More

thumbnail for video 05 - a powerful chart has a high signal-to-noise ratio

A powerful chart has a high signal-to-noise ratio

‘Less is more’. It’s a crucial principle in most of our communication, and in data visualization in particular. Because of my background as a physicist, I prefer to talk about the ‘signal-to-noise ratio’. The message - our signal - should be amplified as much as possible, giving it all of the attention. Everything that can distract from our message - the noise - should be removed.

Read More

thumbnail for video 04 - a powerful chart tells a story

A powerful chart tells a story

A powerful chart has a clear message. It should be short and meaningful, and obvious in the blink of an eye. If there’s only one thing our audience remembers at the end of the day, this should be it.

Read More

Navigating the landscape of powerful charts

Once we’ve decided to create a data visual or infographic, there are a lot of questions we should ask ourselves to determine the most suitable format. These considerations could include size, readability, possible interactive functionality, and the level of detail we need.

Read More

Kenneth Mejia's billboard in the city of Los Angeles, showing a bar chart with a breakdown of the city budget.

How powerful charts can boost your career

An American accountant managed - as the youngest ever! - to win a crucial election in Los Angeles - thanks to the power of data visualization. And you, too, can use powerful charts to boost your career!

Read More

We are really into visual communication!

Every now and then we send out a newsletter with latest work, handpicked inspirational infographics, must-read blog posts, upcoming dates for workshops and presentations, and links to useful tools and tips. Leave your email address here and we’ll add you to our mailing list of awesome people!