Three tips to create powerful charts in Excel

Three tips to create powerful charts in Excel

Microsoft Excel can be a powerful tool for making sense of complex data sets, and for visualizing them. By creating charts and graphs in Excel, you can quickly and easily identify trends, patterns, and outliers in your data. This can help you to gain valuable insights and make more informed decisions.

However, creating effective data visualizations in Excel can also be challenging. Excel is not specifically designed for creating charts and graphs, so it can be difficult to get them to look exactly the way you want. The default option presented by Excel is often not the most pretty one.

Additionally, Excel doesn’t always make it easy to format and customize charts, which can make it difficult to create visualizations that accurately and effectively communicate your data. Creating data visualizations in Excel can be time-consuming, especially if you have a large amount of data to work with.

However, if you’re not willing to spend time or resources on other tools, Excel can get you quite far in creating beautiful, powerful charts – as long as you apply some basic data visualization principles.

📊 Here are our top three tips to create powerful charts in Excel:

1. Abandon the defaults

Excel’s default chart settings are not meant to make your chart look good, they’re meant to help you get an idea of what’s possible. Feel free to add or remove gridlines, data labels or legends as you see fit to make your chart more clear and more beautiful.

2. Find more suitable colors

Excel’s default color scheme is not exactly ideal. Each of the colors feels equally important, so it’s difficult to create a clear visual hierarchy. Use a tool like Coolors, ColorBrewer or the Data Color Picker to find a palette that matches the theme of the visual and allows you to use a strong accent color if needed. Don’t forget to use grey to send less important elements to the background!

3. Make combinations of charts

Excel’s chart options are substantial, but also have their limits. Sometimes you’ll have to group different charts together to reach the desired result. The butterfly chart below was created by grouping two separate bar charts (make sure they use the same scale!) and adding a text box to act as a title.

Read more:

thumbnail for video 09 - choosing the right font for your data visual

Choosing the right font for your data visual

Fonts evoke emotions: there are very sophisticated fonts, playful fonts, attention-grabbing fonts, and elegant handwritten fonts. Using the wrong type of font can have a lot of impact. In data visualization the implications of typography are mainly focused on readability. Labels and annotations can easily become so small they get hard to read. Above all else, we should choose a font which is readable at small sizes.

Read More

thumbnail for video 08 - three roles of colour in a data visual

Three roles of colour in a data visual

Colour is one of the most crucial tools we have to turn a normal chart into a powerful chart with a clear message, a chart which tells a story rather than simply presenting the information.

Read More

thumbnail for video 07 - 7 different goals for your chart

7 different goals for your chart

A crucial step in building a powerful chart is choosing the right type of chart. A lot of charts don’t work because they simply use the wrong type of chart. To avoid this trap, we must ask ourselves a basic question: what’s the ultimate goal of our data visual? What do we want to show with our data?

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

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!


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

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.

Noise: the enemy of communication

Maximizing the signal-to-noise is important for every form of communication. A company that applies this principle very well is Apple. In their presentation of the first iPhone, back in 2007, the signal-to-noise ratio is very high.

Steve Jobs presenting the first iPhone

On the slide is just a picture of the iPhone with a single word: GPS. That’s what this part of the presentation is about: here’s our new phone, and it has GPS!

There’s nothing else on the slide – no slide numbers, dates or logos. Not even the Apple logo! Both the slide and the room have a dark background. Steve Jobs is not behind his desk, because it would be a barrier between him and the audience. He’s wearing neutral clothes, because anything too fancy might distract from the message. Every possible source of noise has been eliminated.

Noise in data visualization

Apple still does this today, and they do it in their data visualization as well. This very clean chart was a part of their 2020 presentation of the M1 chip. Again, it has a noise-free dark background. Everything unnecessary is removed. There are no gridlines or axis ticks. There is not even a legend!

Chart describing the power of Apple's M1 chip compared to conventional pc chips

Remove the unnecessary

Here’s another practical example of signal-to-noise ratio applied to data visuals. From this chart we can remove the coloured background, the gridlines, the legend, and even the horizontal and vertical axes. Removing these elements doesn’t harm the data or the message of the visual. In fact, it makes the data even more accessible. That means they were just noise! We end up with a much clearer visual, with a much higher signal-to-noise ratio.

A bar chart with a lot of noise.
The same bar chart, now with a much higher signal-to-noise ratio

If you want to know more about visualizing data in the right way, you can check out the other videos in this series. Or I invite you to read my book, Powerful Charts, that will give you actionable insights and practical guidelines to create data visuals that truly engage and inspire your audience.

Read more:

thumbnail for video 09 - choosing the right font for your data visual

Choosing the right font for your data visual

Fonts evoke emotions: there are very sophisticated fonts, playful fonts, attention-grabbing fonts, and elegant handwritten fonts. Using the wrong type of font can have a lot of impact. In data visualization the implications of typography are mainly focused on readability. Labels and annotations can easily become so small they get hard to read. Above all else, we should choose a font which is readable at small sizes.

Read More

thumbnail for video 08 - three roles of colour in a data visual

Three roles of colour in a data visual

Colour is one of the most crucial tools we have to turn a normal chart into a powerful chart with a clear message, a chart which tells a story rather than simply presenting the information.

Read More

thumbnail for video 07 - 7 different goals for your chart

7 different goals for your chart

A crucial step in building a powerful chart is choosing the right type of chart. A lot of charts don’t work because they simply use the wrong type of chart. To avoid this trap, we must ask ourselves a basic question: what’s the ultimate goal of our data visual? What do we want to show with our data?

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

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!


thumbnail for video 04 - a powerful chart tells a story

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.

Answering the ‘so what’ question

A visual without a clear key message might show the data, but it doesn’t show what’s interesting, surprising or noteworthy about the data. It leaves our audience guessing, they have to do all of the thinking work. Ideally, we want to create a visual that helps them to quickly see what’s important. A visual that not only answers the ‘what’ question, but more importantly also the ‘so what’ question.

Here’s one of my favourite examples to illustrate the importance of visual storytelling. This chart shows the evolution of meat consumption in the US since the 1960s. By itself, this chart is pretty clear. It shows us the data, in a way that is easy to understand. It answers the ‘what’ question. The design is satisfactory, with pleasing colours and good readability. But can it be improved?

US per capita consumption of poultry and livestock

Here is an attempt at a rework. Even though we’re looking at exactly the same data – we wouldn’t want to lie to our audience! – the message in this new visual is loud and clear. It’s right there in the title: Americans are eating more chicken than ever before!

Americans are eating more chicken than ever before

The power of data visualization at work

Two simple changes turned the original ‘what’ visual into this super-clear ‘so what’ visual.

  • First of all, clever colour choices: the line that interests us – the one for chicken consumption – gets a bright orange colour, the other two become grey. They’re still there, but pushed a bit to the background.
  • Secondly, clever text: the original title was very factual – ‘US per capita consumption of poultry and livestock’. All the thinking work is left for the reader. But what if we simply tell them the interesting part? The new title ‘Americans are eating more chicken than ever before’ is still 100% true, but now it tells us why this visual is actually quite surprising.

These two small but impactful changes turned the original visual, which simply shows the data, into a great visual that actually tells a story. For me, that’s the real power of data visualization at work.

If you want to know more about visualizing data in the right way, you can check out the other videos in this series. Or I invite you to read my book, Powerful Charts, that will give you actionable insights and practical guidelines to create data visuals that truly engage and inspire your audience.

Read more:

thumbnail for video 09 - choosing the right font for your data visual

Choosing the right font for your data visual

Fonts evoke emotions: there are very sophisticated fonts, playful fonts, attention-grabbing fonts, and elegant handwritten fonts. Using the wrong type of font can have a lot of impact. In data visualization the implications of typography are mainly focused on readability. Labels and annotations can easily become so small they get hard to read. Above all else, we should choose a font which is readable at small sizes.

Read More

thumbnail for video 08 - three roles of colour in a data visual

Three roles of colour in a data visual

Colour is one of the most crucial tools we have to turn a normal chart into a powerful chart with a clear message, a chart which tells a story rather than simply presenting the information.

Read More

thumbnail for video 07 - 7 different goals for your chart

7 different goals for your chart

A crucial step in building a powerful chart is choosing the right type of chart. A lot of charts don’t work because they simply use the wrong type of chart. To avoid this trap, we must ask ourselves a basic question: what’s the ultimate goal of our data visual? What do we want to show with our data?

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

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!


Navigating the landscape of powerful charts

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.

Consider your audience

Our audience is crucial in this: in the end, it’s all about them. Even when we have the most important message in the world, if our audience doesn’t understand it or they’re not interested, it’s all for nothing.

So, take a moment to consider what your audience is trying to achieve. Which decision are they trying to make? What data or information do they need in order to make this decision? And how much time do they have to do so?

The landscape of powerful charts

Depending on our answers to these questions, the charts we create can vary wildly. If time is of the essence, we should build charts which can be interpreted in the blink of an eye. These could be static charts for reports, animated online charts, or interactive charts in mobile applications.

On the other end of the spectrum we have a bit more time for visual storytelling. This includes infographics for print or social media, or maybe breathtaking interactive visual essays. We can take our audience by the hand and guide them, step by step, through a visual story.

In between these two extremes we can create reports or dashboards that can guide our audience through a collection of clearly presented key insights.

the landscape of powerful charts

Don’t start your computer (yet)

Once we have figured out our place in this landscape of powerful charts, the production of our visual can start. However, I urge you not to open your computer at this point of the workflow. It’s a common mistake: we want to start creating as quickly as possible, so we open our favourite tool right away. But then it hits us – the blank screen is staring us in the face, and we start doubting. Where should we put the first line? What was it again we were trying to achieve?

We’re not there yet. It’s time to first define a clear message.

If you want to know more about visualizing data in the right way, you can check out the other videos in this series. Or I invite you to read my book, Powerful Charts, that will give you actionable insights and practical guidelines to create data visuals that truly engage and inspire your audience.

Read more:

thumbnail for video 09 - choosing the right font for your data visual

Choosing the right font for your data visual

Fonts evoke emotions: there are very sophisticated fonts, playful fonts, attention-grabbing fonts, and elegant handwritten fonts. Using the wrong type of font can have a lot of impact. In data visualization the implications of typography are mainly focused on readability. Labels and annotations can easily become so small they get hard to read. Above all else, we should choose a font which is readable at small sizes.

Read More

thumbnail for video 08 - three roles of colour in a data visual

Three roles of colour in a data visual

Colour is one of the most crucial tools we have to turn a normal chart into a powerful chart with a clear message, a chart which tells a story rather than simply presenting the information.

Read More

thumbnail for video 07 - 7 different goals for your chart

7 different goals for your chart

A crucial step in building a powerful chart is choosing the right type of chart. A lot of charts don’t work because they simply use the wrong type of chart. To avoid this trap, we must ask ourselves a basic question: what’s the ultimate goal of our data visual? What do we want to show with our data?

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

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!


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

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.

Kenneth Mejia, a 32-year-old accountant of Filipino descent, is very committed to issues of poverty, affordable housing and mobility. In the 2022 elections he ran for “City Controller”, a sort of treasurer, for his hometown of Los Angeles. It’s a department with responsibilities almost as big as those of the city’s mayor and chief justice. For example, the City Controller can commission audits to evaluate the effectiveness of city departments.

Data visualization as election propaganda

Kenneth took a remarkably creative and unusual approach in the run-up to the election: he made imported data about the city instantly accessible and visible. On his campaign website, for example, he created a whole series of interactive maps, reports and searchable databases. He even put up billboards showing with graphs what the anticipated city budget will be used for in 2022-2023.

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

That transparent communication did not miss its mark. Kenneth won, as the youngest city controller ever. This approach shows how powerful data visualization is to unlock information, which may seem difficult and unfathomable to the general public, in a very accessible way. As a result, citizens not only gain insight but also become more engaged in politics. They become better informed and can vote more knowledgeably.

You too can make a difference thanks to powerful data visualization

Whether you have political ambitions, want to present your scientific research comprehensibly or convince your management of your brilliant ideas… Would you also like to learn how to create powerful graphics that can inform, convince and engage your audience? Charts that not only accurately represent the numbers, but also have a clear message and are attractive to look at?

In the book “Powerful Charts” physicist and Baryon founder Koen Van den Eeckhout explains in an accessible and practical way how this can be done. An indispensable guide for anyone who communicates with and about figures.

This brand new book is available now at Owl Press.

Order the book here

Read more:

thumbnail for video 09 - choosing the right font for your data visual

Choosing the right font for your data visual

Fonts evoke emotions: there are very sophisticated fonts, playful fonts, attention-grabbing fonts, and elegant handwritten fonts. Using the wrong type of font can have a lot of impact. In data visualization the implications of typography are mainly focused on readability. Labels and annotations can easily become so small they get hard to read. Above all else, we should choose a font which is readable at small sizes.

Read More

thumbnail for video 08 - three roles of colour in a data visual

Three roles of colour in a data visual

Colour is one of the most crucial tools we have to turn a normal chart into a powerful chart with a clear message, a chart which tells a story rather than simply presenting the information.

Read More

thumbnail for video 07 - 7 different goals for your chart

7 different goals for your chart

A crucial step in building a powerful chart is choosing the right type of chart. A lot of charts don’t work because they simply use the wrong type of chart. To avoid this trap, we must ask ourselves a basic question: what’s the ultimate goal of our data visual? What do we want to show with our data?

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

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!


Why is data visualization so challenging?

Why is data visualization so challenging?

Data visualization is very powerful, but it can also be hard. That’s because a great data visual combines three different aspects simultaneously.

The three properties of a great data visual

  • A great data visual is clear: it communicates a strong message and is easy to understand without too much additional explanation.
  • A great data visual is correct: it presents the data in an accurate and appropriate way, and is unambiguous.
  • A great data visual is beautiful: it is inviting to look at, and uses colour, typography and other design elements in the right way to support its message.

the venn diagram of great data visuals, showing that a great data visual is simultaneously clear, correct and beautiful

That also implies that we, as data visualizers, need to consider three different aspects when creating a data visual:

  • the communication aspect, in order to make our visual clear,
  • the analytical aspect, in order to make it correct, and
  • the design aspect, in order to make it beautiful.

If one of these aspects is missing, we end up with a suboptimal chart. A chart can be beautiful and correct but confusing to navigate, causing the message to be lost. Or it can be very beautiful and clear, but fall apart because the underlying data or the representation of it is flawed. A lot of charts we encounter are clear and correct, but simply boring or uninviting to look at, because they were not designed to look good.

Three different skills

So, in order to create a powerful chart we must apply our communication, our analytical ánd our design skills. Most people feel comfortable with one or two of these skill sets, but not with all of them. Many people in analytical jobs, such as researchers, engineers or consultants, struggle with the design aspects of a visual. People with a role in communication, such as journalists or marketeers, often feel uncomfortable to dive into data analytics and the theoretical principles behind charts. And professional designers can make their visuals look beautiful, but don’t always succeed in crafting a crystal-clear message.

If you recognize yourself in one of these worries, fear not! I am convinced that anyone can create great data visuals on the intersection of clarity, correctness and beauty.

If you want to know more about visualizing data in the right way, you can check out the other videos in this series. Or I invite you to read my book, Powerful Charts, that will give you actionable insights and practical guidelines to create data visuals that truly engage and inspire your audience.

Read more:

thumbnail for video 09 - choosing the right font for your data visual

Choosing the right font for your data visual

Fonts evoke emotions: there are very sophisticated fonts, playful fonts, attention-grabbing fonts, and elegant handwritten fonts. Using the wrong type of font can have a lot of impact. In data visualization the implications of typography are mainly focused on readability. Labels and annotations can easily become so small they get hard to read. Above all else, we should choose a font which is readable at small sizes.

Read More

thumbnail for video 08 - three roles of colour in a data visual

Three roles of colour in a data visual

Colour is one of the most crucial tools we have to turn a normal chart into a powerful chart with a clear message, a chart which tells a story rather than simply presenting the information.

Read More

thumbnail for video 07 - 7 different goals for your chart

7 different goals for your chart

A crucial step in building a powerful chart is choosing the right type of chart. A lot of charts don’t work because they simply use the wrong type of chart. To avoid this trap, we must ask ourselves a basic question: what’s the ultimate goal of our data visual? What do we want to show with our data?

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

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!


Books on a bookshelf - infographics resources

Data visualization resources: all the links you'll ever need!

Data visualization: all the resources you'll ever need!

You want to start creating clear and attractive data visuals, but don’t know where to start? No worries, here’s a complete overview of tools, resources and inspiration you can use as a starting point for your designs.

Finding useful datasets

Inspiration for data visualization

Digital tools to create infographics and data visuals

Illustrations and icons

Colour schemes

Typography

Creating graphs

Creating maps

Creating tables

Ethics in data visualization

  • Dealing with outliers: https://flowingdata.com/2018/03/07/visualizing-outliers/
  • Visualizing projections and missing data: https://flowingdata.com/2018/01/30/visualizing-incomplete-and-missing-data/
  • Spurious correlations: https://www.tylervigen.com/spurious-correlations
  • About dynamite plots: http://biostat.mc.vanderbilt.edu/wiki/Main/DynamitePlots
  • Alternatives to box plots: https://nightingaledvs.com/ive-stopped-using-box-plots-should-you/
  • Visualizing the uncertainty in data (Flowing Data): https://flowingdata.com/2018/01/08/visualizing-the-uncertainty-in-data/
  • Visualizing uncertainty (Claus Wilke): https://clauswilke.com/dataviz/visualizing-uncertainty.html

Books about infographics and data visualization

  • Data visualisation, Andy Kirk
  • Dear Data, Giorgia Lupi & Stefanie Posavec
  • Information graphics, Taschen
  • Infographic designers’ sketchbooks, Steven Heller & Rick Landers
  • Storytelling with data, Cole Nussbaumer Knaflic
  • The visual display of quantitative information, Edward Tufte
  • Trees, maps and theorems, Jean-Luc Doumont
  • Visual journalism, Gestalten
  • Visual thinking, Willemien Brand

People on Twitter talking about data

Videos about data visualization

Dataviz blogs and online magazines

Dataviz podcasts

Books on a bookshelf - infographics resources

Read more:

thumbnail for video 09 - choosing the right font for your data visual

Choosing the right font for your data visual

Fonts evoke emotions: there are very sophisticated fonts, playful fonts, attention-grabbing fonts, and elegant handwritten fonts. Using the wrong type of font can have a lot of impact. In data visualization the implications of typography are mainly focused on readability. Labels and annotations can easily become so small they get hard to read. Above all else, we should choose a font which is readable at small sizes.

Read More

thumbnail for video 08 - three roles of colour in a data visual

Three roles of colour in a data visual

Colour is one of the most crucial tools we have to turn a normal chart into a powerful chart with a clear message, a chart which tells a story rather than simply presenting the information.

Read More

thumbnail for video 07 - 7 different goals for your chart

7 different goals for your chart

A crucial step in building a powerful chart is choosing the right type of chart. A lot of charts don’t work because they simply use the wrong type of chart. To avoid this trap, we must ask ourselves a basic question: what’s the ultimate goal of our data visual? What do we want to show with our data?

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

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!


thumbnail for video 01 - why is data visualization so powerful

Why is data visualization so powerful?

Why is data visualization so powerful?

The amount of data coming our way is growing exponentially. In 2021 alone, it is estimated that humankind generated 74 zettabytes of data – that’s about 10,000 GB per person. How on earth are we going to keep this manageable?

Visualization: our most powerful tool

Visualization is one of the key solutions to cope with the endless stream of data, content and information – together with other strategies such as filtering and organization. Visualization might very well be the most powerful tool we have to turn complex information into manageable insights. But why is that?

There are three important reasons why data visualization is a very strong way to present information:

  1. its information density is extremely high,
  2. it attracts the attention of your audience, and
  3. visual information is easier to process and memorize.

Reason 1: information density

Researchers at MIT have shown that we can detect the meaning of a picture in as little as 13 milliseconds – that’s extremely fast.

We could spend hours looking at this dataset for example, created by visual journalism professor Alberto Cairo, without learning anything. But as soon as we turn the data into a scatter plot, it’s obvious that we’re looking at a dinosaur. In the blink of an eye!

The datasaurus dataset, developed by Albert Cairo, looks like a dinosaur when plotted in a two-dimensional scatter plot.

Reason 2: attractiveness

Visual information is also attractive. Not in the sense that it is beautiful to look at (although that’s often also our goal), but literally: it attracts the attention of your audience. In a book or newspaper, people will often look for the pictures first, before they start reading all of the text.

Reason 3: easier to process

Finally, charts and infographics are easier to process than written text. The dual-coding theory, developed by Allan Paivio, states that our brains process information both in a visual, as well as a verbal way. If we only get verbal stimuli, only a part of our brain is working. That’s why during a long phone call we automatically start doodling – the visual brain is bored and looking for things to do. By providing our audience with a combination of text and images, the entire brain is stimulated, leading to better focus, better understanding, and better memorization.

A visual summary of the dual coding theory, showing how a tree can be presented simultaneously as a visual stimulus and a verbal stimulus.

Harnessing the power of data visualization

So in summary, data visualization is powerful because it combines a high information density, attractiveness, and easier processing and memorization.

If you want to know more about visualizing data in the right way, you can check out the other videos in this series. Or I invite you to read my book, Powerful Charts, that will give you actionable insights and practical guidelines to create data visuals that truly engage and inspire your audience.

Read more:

thumbnail for video 09 - choosing the right font for your data visual

Choosing the right font for your data visual

Fonts evoke emotions: there are very sophisticated fonts, playful fonts, attention-grabbing fonts, and elegant handwritten fonts. Using the wrong type of font can have a lot of impact. In data visualization the implications of typography are mainly focused on readability. Labels and annotations can easily become so small they get hard to read. Above all else, we should choose a font which is readable at small sizes.

Read More

thumbnail for video 08 - three roles of colour in a data visual

Three roles of colour in a data visual

Colour is one of the most crucial tools we have to turn a normal chart into a powerful chart with a clear message, a chart which tells a story rather than simply presenting the information.

Read More

thumbnail for video 07 - 7 different goals for your chart

7 different goals for your chart

A crucial step in building a powerful chart is choosing the right type of chart. A lot of charts don’t work because they simply use the wrong type of chart. To avoid this trap, we must ask ourselves a basic question: what’s the ultimate goal of our data visual? What do we want to show with our data?

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

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!


Amazing facts about the brain - teaser

Infographic: Amazing facts about the brain

Infographic

Amazing facts about the brain

🧠 Did you know that our brain makes up 2% of our body weight, but consumes as much as 20% of our energy? Did you know that we have a second brain, located in our gut?

Our information designer Sofia is very passionate about our brain and how it works. She made this insightful brain infographic, giving you an overview of eight amazing facts about the brain!

If you’re looking for your own infographic to share a fascinating story with your audience, we’re here to help! Find out what we can do for you.

Eight amazing facts about the brain infographic

Read more:

thumbnail for video 09 - choosing the right font for your data visual

Choosing the right font for your data visual

Fonts evoke emotions: there are very sophisticated fonts, playful fonts, attention-grabbing fonts, and elegant handwritten fonts. Using the wrong type of font can have a lot of impact. In data visualization the implications of typography are mainly focused on readability. Labels and annotations can easily become so small they get hard to read. Above all else, we should choose a font which is readable at small sizes.

Read More

thumbnail for video 08 - three roles of colour in a data visual

Three roles of colour in a data visual

Colour is one of the most crucial tools we have to turn a normal chart into a powerful chart with a clear message, a chart which tells a story rather than simply presenting the information.

Read More

thumbnail for video 07 - 7 different goals for your chart

7 different goals for your chart

A crucial step in building a powerful chart is choosing the right type of chart. A lot of charts don’t work because they simply use the wrong type of chart. To avoid this trap, we must ask ourselves a basic question: what’s the ultimate goal of our data visual? What do we want to show with our data?

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

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!


Birthday heatmap

How common is your birthday?

How common is your birthday?

Not all birthdays are created equal… in fact, for most countries in the north temperate zone, more people are born in summer (May – August) than in winter (October – January). This heatmap allows you to check how popular your birth date is. It shows the number of people in Belgium for each specific birthday.

There are some interesting outliers: January 1st and July 1st are extra common, because people with an unknown birth data are commonly assigned these birthdays. The national holidays (May 1, July 21, August 15, November 1 and 11, December 25) are clearly visible as dips in the data. And obviously, February 29th is also not very popular!

We haven’t figured out why more people are born on the 1st, 5th, 10th, 15th, 20th and 25th of each month, but possibly this has some administrative reasons as well…

Man using a calendar for remembering an appointment

Read more:

thumbnail for video 09 - choosing the right font for your data visual

Choosing the right font for your data visual

Fonts evoke emotions: there are very sophisticated fonts, playful fonts, attention-grabbing fonts, and elegant handwritten fonts. Using the wrong type of font can have a lot of impact. In data visualization the implications of typography are mainly focused on readability. Labels and annotations can easily become so small they get hard to read. Above all else, we should choose a font which is readable at small sizes.

Read More

thumbnail for video 08 - three roles of colour in a data visual

Three roles of colour in a data visual

Colour is one of the most crucial tools we have to turn a normal chart into a powerful chart with a clear message, a chart which tells a story rather than simply presenting the information.

Read More

thumbnail for video 07 - 7 different goals for your chart

7 different goals for your chart

A crucial step in building a powerful chart is choosing the right type of chart. A lot of charts don’t work because they simply use the wrong type of chart. To avoid this trap, we must ask ourselves a basic question: what’s the ultimate goal of our data visual? What do we want to show with our data?

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

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!