How to Change Data Point Colors in Charts in Google Sheets

Published on

Google Sheets allows for customizing the color of individual data points in its charts, wherever applicable.

With this feature, you can adjust the color of individual bars in a Bar chart, columns in a Column chart, bubbles in a Bubble chart, and data points in a Line and Scatter chart.

Why is this feature important?

Custom colors can be used to highlight specific data points of particular interest or importance, such as status indicators (e.g., red for critical, green for normal), drawing the viewer’s attention.

The default data point colors will depend on the Format menu theme color. When you change the theme, the customized data point colors will also adjust.

Therefore, I recommended choosing the theme color you want before attempting to change individual data point colors of the series.

Let’s explore how to change the data point colors in Bar, Column, Scatter, Bubble, and Line Charts in Google Sheets.

Change Data Point Colors in Bar, Column, and Scatter Charts in Google Sheets

When it comes to changing individual data point colors, these three graphs share the same settings.

Here are the steps to change the color of individual bars in a Bar chart, columns in a Column chart, and data points in a Scatter plot:

To customize the color of an individual data point, navigate to the “Customize” tab of the Chart editor.

Under “Series,” click on the “Add” button next to “Format data point.”

Adding data points to customize the color in Bar, Column, and Scatter Charts

This will prompt you to select the data point, for which you want to change the color from a drop-down menu. Choose the one you want and click OK.

Picking data points from a drop-down

Then, select a color from the color palette to apply to this data point, and you’re done!

This method allows you to highlight specific data and convey additional information in Bar, Column, and Scatter charts.

Customizing Colors for Bubbles in Bubble Charts

By default, each data point (bubble) has a different color in the Bubble chart, so additional customization won’t make much of an impact.

To customize the bubble color in Bubble charts, navigate to the Chart editor > Customize tab > Series. From there, you can select each data point by its label and change the color.

Customizing Colors for Bubbles in Bubble Charts

Customizing Data Point Colors in Line Charts

Most settings are similar to those in Bar, Column, and Scatter charts. However, there is one additional setting.

Navigate to the “Customize” tab of the Chart editor and select the “Series” for which you want to display the data points and change colors.

Under “Point size,” select a point size. Click “Add” next to “Format Data Point” and choose the desired data point, then click OK. Select a fill color.

Adding Data Points and Customizing Data Point Colors in Line Charts

Resources

Here are some guides with tips and tricks for Google Sheets charts.

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Finding Most Frequent Text in Excel with Dynamic Array Formulas

Looking to identify the most frequently occurring text in Excel? You can do this...

Hierarchical Numbering Sequences in Excel

Creating hierarchical numbering sequences in an Excel spreadsheet can significantly improve the way you...

How to Easily Repeat a Sequence of Numbers in Excel

Excel offers multiple ways to accomplish tasks, and the simplicity of each approach depends...

Create a Sequence of Dates at Every Nth Row in Excel (Dynamic Array)

Would you like to create a sequence of dates in every nth row in...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

1 COMMENT

  1. So, Google Sheets has no color set for values? can’t I set green for +80%, yellow for 40-79% and red to <39%?

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.