Can you use Excel to create a powerful chart?

Spreadsheet tools such as Microsoft Excel or Numbers might not be the first thing on your mind when considering data visualization tools, but they can be pretty solid choices to build data visuals. Don’t let anyone convince you that using Excel to create data visuals is unprofessional. In my practice as an information designer I have created many charts in both Excel and PowerPoint, in particular for clients who wanted some degree of flexibility in modifying the visuals themselves.

Spreadsheet tools are more powerful than you might think

Spreadsheet applications allow us to create almost any type of chart in the family of bar charts, line charts and pie charts – including stacked bar charts, area charts, and so on. But even more ‘exotic’ alternatives such as treemaps, sunburst diagrams, candlestick charts, radar charts and waterfall charts are available.

The strength of spreadsheet tools lies more in building the charts than in polishing their design. We could use Excel to create the basic shapes that will make up the core of the data visual, and then export them to another, more design-oriented tool such as PowerPoint or Adobe Illustrator to further modify the colours, annotations and layout – or to combine multiple graphs into a single chart. Nevertheless, most of these things are possible in spreadsheet tools as well, although they might require a bit more tinkering and clicking around.

Move away from the defaults

The challenge in these situations is to move away from the default options. It takes some time and patience, and maybe some visual trickery, but it pays off!

This is how a default visual might look like: it has no visual hierarchy, boring default colors, the legend takes up a lot of space, and the numbers are hard to read.

Groundwater use by agriculture in Flanders

In the reworked visual below we changed the orientation of the bar chart from vertical to horizontal, we chose a better colour scheme, and we used direct labelling to remove the legend and gridlines. The end result contains exactly the same data as the default chart, but presented in a much clearer and more structured way.

Reworked visual of the groundwater bar chart

Both of these charts were created from scratch using nothing but Microsoft Excel. Creating powerful charts is not about the tools you use, it’s all about applying the right principles!

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:

Books on a bookshelf - infographics resources

Data visualization resources: all the links 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.

Read More

thumbnail for video 01 - 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?

Read More

Amazing facts about the brain - teaser

Infographic: Amazing facts about the brain

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

Our information designer Sofia made this insightful infographic, giving you an overview of eight amazing facts about the brain!

Read More

Birthday heatmap

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.

Read More

Visualizing complexity by Superdot: interior

Visualizing Complexity: Dataviz book review

Visualizing Complexity is a great new data visualization book published by information design Superdot. Here's our verdict.

Read More

This chart is trying to trick you

The original chart in this example is trying to suggest a strong correlation between sugar intake and obesity in the US between 1980 and 2000. It does so by carefully choosing the vertical axis ranges and scaling so both lines nicely fall on top of each other.

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!