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 10 - can you use excel to create a powerful chart

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.

More info

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.

More info

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.

More info

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?

More info

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.

More info

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.

More info

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!