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:
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.
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?
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!
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.
Visualizing Complexity: Dataviz book review
Visualizing Complexity is a great new data visualization book published by information design Superdot. Here's our verdict.
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.
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!
