How to Pick the Best Colors For Graphs and Charts? (2024)

Home > Blog > Data Visualization > Add-ons > Google Sheets >

Data visualization has become an essential part of businesses today. These days more is needed to visualize with charts and graphs. Customers expect more from such visualizations.

Here’s the secret.

You can impress your customers and target audience by using the best colors for graphs. Using the most suitable colors for your charts and graphs can help you easily communicate your ideas and insights.

In this blog, you will learn the best colors for charts and graphs depending on your audience’s wants. This way, you can persuade potential customers and build a brand for your products and services.

Table of Content:

  1. The Importance of Colors in a Graph
  2. The Meaning of Color in Our Lives
  3. How to Define Thoughtful, Useful Palettes?
  4. Things to Keep in Mind When Choosing the Best Colors for Graphs
  5. The Do’s for Data Visualization Colors
  6. The Don’ts for Data Visualization Colors
  7. Common Data Visualization Color Palettes
  8. Examples of Best Colors for Excel Charts
  9. Top 5 Best Practices For Using Colors in Graphs
  10. Wrap Up

Are you ready to learn more about colors? Let’s go.

The Importance of Colors in a Graph

Every color you have known since childhood has its unique features and abilities. Most people bypass the importance of colors because they are unaware of the science colors have in our brains.

Imagine what it would be like if the world didn’t have different colors. Would everything appear dull, right? When it comes to data visualization, colors play a critical role in persuasion and attraction.

One interesting fact about your brain is that it chemically reacts to every color to trigger an emotional response.

Colors create associations and thoughts about a brand or event. If your goal is to persuade your audience to subscribe to a product or service, use the best colors for graphs and chord diagrams.

Each color has its unique abilities and how your audience reacts to every one of them. Colors directly affect your target audience’s perception of your graphs and charts.

Various business owners apply this knowledge of colors to create their unique brands. For instance, restaurants and cafes use Orange or Brown colors to make customers feel at home. Orange and brown are also effective choices for visual presentations, such as in a Side-By-Side Bar Chart, where they can help differentiate data clearly and make the information more engaging

However, some brands and professionals need to improve in properly using colors. They need to use the best color for the Sunburst Chart and other visualizations on their websites to make their brand more appealing.

For instance, in a dot plot, the right choice of colors can significantly enhance the readability and impact of the data presented. Analysts and data scientists still need to recognize the proper use of colors and graph types, like Box and Whisker graphs, to communicate their insights effectively. Don’t make the same mistake too.

That is why choosing colors for your data visualizations with human psychology in mind is vital. Whether you are creating a Radar Chart or any other type of visualization, it’s essential to understand the different meanings of colors in their various contexts.

The Meaning of Color in Our Lives

Each color has a meaning in your life. Each human experiences colors in significantly different ways. Each individual has unique emotions and cultural and societal affiliations with varying perceptions of colors.

However, some colors are universally accepted by almost every individual. When we understand such colors, we can appreciate the best colors for graphs, especially for Funnel charts.

Let’s use the example of green and red because they are the most common. We know these colors to have opposite meanings, especially if you obey traffic lights daily. In traffic rules, the red light tells you to stop, the orange light tells you to prepare, and the green light tells you to go.

In essence, red is a universal color that signifies danger or caution. However, sports analytics reveals that some sports brands use red in their logos and sports jerseys to convey confidence and power.

How to Define Thoughtful, Useful Palettes?

Let’s assume you’re creating a Google Ads performance dashboard.

You will have to work with two or three striking colors in this case. Still, your chart needs to display performances for your agency’s 18 campaigns.

It would not be effective if you recycled a three-shade palette. Still, using one color for the four ad categories won’t be appropriate.

Each time a team member views the dashboard, they will strain their eyes to see tiny labels and legends to obtain insights. Therefore, action must be taken so that the dashboard benefits those who walk past it and take a glance.

What options will you have?

When you decide on the best color for graphs, a standard option is to use your few brand colors and into many small colors. These small color segments progressively reduce their saturation, and their hues become darker, as shown below.

The resulting chart will be muddy and unappealing to your audience.

Another option you can use is the application of random non-deliberate colors. In this case, you might use colors outside your brand and rarely use them.

The palettes will appear as shown below.

Although you will succeed in finding different shades, it doesn’t show a contrast between them, and thus it will not appear cohesive.

The two options we have mentioned cannot create a high-impact data visualization.

To ensure that you succeed in on-brand visualization with several categories, you must take your time to color each category. For instance, in a 20-color brand palette, please keep it simple and appealing for more straightforward visualizations.

The best way to generate an extensive palette is to utilize light shades of your original brand colors in between them. This strategy is essential since it will stretch the palette.

Things to Keep in Mind When Choosing the Best Colors for Graphs

Appropriateness

Some colors are specific to some industries. For instance, many financial institutions will use blue as their brand to signify authority, stability, and customer value.

When choosing the best colors for graphs, you can choose depending on what mood you want to set for your audience. Data storytelling techniques can help you decide on colors that enhance your narrative. Blue can be appropriate if you want to set a soothing mood.

Your Target Audience

It is essential to consider your target audience’s background and culture when choosing the best colors for graphs, including when creating a Mekko Chart. Various cultures perceive colors differently, so selecting the right color scheme can enhance the chart’s effectiveness and clarity.

For instance, in some Asian cultures, red and gold cultures signify wealth and fortune. You can easily impress Asian investors with such colors in your data visualization.

The Do’s for Data Visualization Colors

  1. Do use colors to create associations. This helps you trigger understanding in your audience. For example, you can use green to illustrate business profits and orange to illustrate performance.
  2. Do use a single color to illustrate continuous data. Using one color in continuous data will help your audience identify a metric’s performance.
  3. Do Use Contrasting Colors to show comparisons. This will help your audience note the difference between the two crucial KPIs. Ensure that you use the best contrasting colors for graphs, as selecting the best color for bar charts can significantly enhance clarity and readability.
  4. Do Use Color to Make Important Information Stand Out. You can use gray for less important variables and a highly saturated color for the information you wish to emphasize.

The Don’ts for Data Visualization Colors

  1. Don’t Use Colors that Are Not Easily Distinguishable. The goal is to help your audience interpret your graph without much strain.
  2. Don’t overload your chart with too many colors. This helps your audience identify insights easily. For example, a Circular Chart can be particularly effective when the color scheme is well-chosen. Toomany colors can be confusing to them, so ensure that you use the best color combinations for graphs, including selecting the appropriate slop chart color.
  3. Don’t Forget Accessibility. Always remember that people have different visual abilities. Others suffer from color blindness and cannot distinguish various colors. Accessibility includes using keys or stripes to represent multiple colors.

Common Data Visualization Color Palettes

  1. Qualitative. These color palettes are crucial because they make each color distinct and unique. This becomes efficient when there are no subcategories and when there are unrelated variables.
  2. Sequential. These color palettes use a single color with varying saturation levels. They are ideal for representing a single KPI that changes over time, especially in visualizations like a Pyramid diagram.
  3. Diverging. Diverging palettes use different colors on each. The neutral point is a mix of the end colors. These palettes are ideal for survey data such as customers’ opinions.

Examples of Best Colors for Excel Charts

  • Sankey Diagram

Let’s use the example of the table below.

Earnings SourceRevenueProceedsExpensesDepartmentsOutflowsAmount
Providing servicesRevenueProceedsExpensesManagerialPersonnel training10000
Providing servicesRevenueProceedsExpensesManagerialOffice rental16000
Providing servicesRevenueProceedsExpensesManagerialWages9400
Renting out premisesRevenueProceedsExpensesCommercialWages11300
Renting out premisesRevenueProceedsExpensesCommercialTravel allowance10000
Renting out premisesRevenueProceedsExpensesCommercialAdvertising12000
Sales of productsRevenueProceedsExpensesProductionMaterial Payment25000
Sales of productsRevenueProceedsExpensesProductionLoan Payment8500
Sales of productsRevenueProceedsExpensesProductionWages19500
LoansProceeds18000

To get started with the best colors for graphs, install the ChartExpo add-in for Google Sheets from this link.

  • Click to open your Google Sheets workbook.
  • In your worksheet, click on the Extensions button.
  • It will drop down the Charts, Graphs & Visualizations by the ChartExpo menu.
  • Click the Open option.

  • Then click on the Add New Chart It will display a list of charts and graphs.

  • Click on the Sankey Chart option to access the chart.

  • Complete the simple process by clicking theCreate Chart button.

  • Your final chart should look like this.

Changing the Color of Nodes

  • To change the color of your Sankey’s nodes, click theEdit Chart button.

  • Click thepencil-like markerson the individual nodes you intend to change color.
  • Click the Node properties section to select theNodeColor box.
  • Hover your mouse over the color you want and click theChoose button.

  • By clicking on Symbols you can add prefixes and postfixes.
  • We add $ in prefix.
  • Click theApply button.
  • For adding a heading click on the pencil icon next to the Chart Header.
  • For saving changes click on Save Changes.

  • Your final chart will appear as shown in the screenshot below.

Insights

Some insights from the Sankey Diagram include the following:

  • Sales of products are a significant contributor to revenue 39%.
  • Loans have the lowest contribution to revenue, with 14%.
  • In the total expenses, Production was a higher expense than any other expense.
  • The Wages also had significantly the highest expense among others, the cost of materials, loan payments, rent, &, etc. are the final outflow of expenses.

  • Clustered Column Chart

Let’s use the table below to visualize your data in Excel.

CitiesQuarter-1Quarter-2Quarter-3Quarter-4
New York500300600650
Chicago400550300400
Austin350400450500
Boston450500550300
Seattle600400300250

To get started with best colors for graphs, install the ChartExpo add-in for Excel from this link.

  • Open your Excel application.
  • Open the worksheet and clickthe Insert button toaccess theMy Apps option.

  • Click the Insert button to initiate the ChartExpo engine.

To get started with ChartExpo in Excel, follow the steps below:

  • Open your Excel application.
  • Open the worksheet and clickthe Insert button toaccess theMy Apps option.

  • Click the Insert button to initiate the ChartExpo engine.

  • Open the ChartExpo add-in. You will see a list of charts.

  • Scroll through, and click Sequence Chart on the list of visualizations as shown.

  • Select your data and click on Create Chart from Selection.

Your Clustered Column Chart will appear as shown below.

Changing colors

  • To change the color of your Clustered Column Chart, click theEdit Chart.

  • Click on the Legend Properties pencil icon to edit.
  • Click on the color of the box to change the color of your legends.
  • Click Apply to change the color of your chart.

Your chart will appear as shown below.

Insights

  • New York has the best performing 4th quarterthan other cities.
  • Seattle has the lowest-performing quarter among the 5 cities.

Top 5 Best Practices For Using Colors in Graphs

  • Limit the Number of Colors: Use a small, distinct palette to avoid overwhelming viewers.
  • Ensure Sufficient Contrast: Choose easily distinguishable colors, even for those with color vision deficiencies.
  • Use Meaningful Colors: Select colors that logically or culturally represent the data, like red for negative and green for positive values, especially when creating a scatter plot.
  • Highlight Key Data: Use a standout color to emphasize important data points or trends.
  • Consider Accessibility: Incorporate patterns or textures along with colors to make graphs accessible to color-blind viewers.

FAQs

What are the best colors for graphs?

The best graph colors for graphs, including Waterfall charts, are blue, green, and orange. You can use these colors to associate specific variables. For instance, you can use green to show profits over time and blue in your charts to create a soothing effect for your audience.

What colors should not be in charts?

You should only use colors that are easily distinguishable in charts. This will leave your audience frustrated as they need help distinguishing various variables.

It is essential to use different colors that will help your audience interpret your graph at a glance.

Why is color important in a graph?

Color is essential in a graph because it triggers an emotional response in your audience. The human brain is easily impressed by colors.

Your aim in coloring your graphs is to easily communicate your insights and persuade your audience to take action.

Wrap Up

In a nutshell, we have learned that data visualization is not enough without using colors.

Colors are essential in creating a visual sense. You can persuade your target audience emotionally by using colors wisely.

As a data visualization designer, it is important to consider human psychology and how individuals react to different colors. You should know how to use the best colors for graphs appropriately.

To successfully communicate your insights, you need to consider your target audience’s cultural perception of colors. This helps you build a brand based on your audience’s favorite color.

ChartExpo third-party application can help you with the appropriate colors for coloring your charts and graphs.

Now it’s your turn. Start a 7-day free trial today with ChartExpo to create charts with appealing colors.

How to Pick the Best Colors For Graphs and Charts? (2024)
Top Articles
3 Fund Portfolio: The Lazy way to Invest
The Only Thing That Matters In Investing: Asset Allocation
Evil Dead Movies In Order & Timeline
Www.1Tamilmv.cafe
Combat level
Jennifer Hart Facebook
Unity Stuck Reload Script Assemblies
Paris 2024: Kellie Harrington has 'no more mountains' as double Olympic champion retires
Usborne Links
How to know if a financial advisor is good?
Obituary (Binghamton Press & Sun-Bulletin): Tully Area Historical Society
Hendersonville (Tennessee) – Travel guide at Wikivoyage
Mustangps.instructure
Routing Number 041203824
Costco in Hawthorne (14501 Hindry Ave)
More Apt To Complain Crossword
Craigslist Pets Longview Tx
The Witcher 3 Wild Hunt: Map of important locations M19
Overton Funeral Home Waterloo Iowa
6813472639
Available Training - Acadis® Portal
Nutrislice Menus
Carolina Aguilar Facebook
Race Karts For Sale Near Me
O'Reilly Auto Parts - Mathis, TX - Nextdoor
Vegito Clothes Xenoverse 2
Target Minute Clinic Hours
Relaxed Sneak Animations
Robotization Deviantart
Riverstock Apartments Photos
Duke University Transcript Request
Calculator Souo
Go Smiles Herndon Reviews
Viewfinder Mangabuddy
That1Iggirl Mega
Td Ameritrade Learning Center
South Bend Tribune Online
Lbl A-Z
Southwest Airlines Departures Atlanta
10 Types of Funeral Services, Ceremonies, and Events » US Urns Online
Youravon Com Mi Cuenta
Kjccc Sports
Samsung 9C8
Strange World Showtimes Near Marcus La Crosse Cinema
Bf273-11K-Cl
How to Find Mugshots: 11 Steps (with Pictures) - wikiHow
Mail2World Sign Up
Poster & 1600 Autocollants créatifs | Activité facile et ludique | Poppik Stickers
Nkey rollover - Hitta bästa priset på Prisjakt
Itsleaa
Equinox Great Neck Class Schedule
Olay Holiday Gift Rebate.com
Latest Posts
Article information

Author: Prof. Nancy Dach

Last Updated:

Views: 6591

Rating: 4.7 / 5 (57 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Prof. Nancy Dach

Birthday: 1993-08-23

Address: 569 Waelchi Ports, South Blainebury, LA 11589

Phone: +9958996486049

Job: Sales Manager

Hobby: Web surfing, Scuba diving, Mountaineering, Writing, Sailing, Dance, Blacksmithing

Introduction: My name is Prof. Nancy Dach, I am a lively, joyous, courageous, lovely, tender, charming, open person who loves writing and wants to share my knowledge and understanding with you.