How to Change Graph Colors in Google Sheets
Your default Google Sheets chart looks a little bland, doesn't it? While the standard blue, red, and yellow get the job done, learning how to change graph colors is the key to creating reports that are not only easier to read but also look professional and on-brand. This tutorial will walk you through exactly how to customize your chart colors, from changing a single bar to using your specific brand colors.
Why Customizing Graph Colors Matters
Before jumping into the "how," it's helpful to understand the "why." Thoughtful color choices can completely transform your data presentation.
- Improves Clarity: The right colors can guide your audience's eyes to the most important information. Highlighting a key metric in a distinct color makes it stand out instantly.
- Enhances Branding: Using your company's color palette creates professional, consistent reports that align with your brand identity. It’s a simple touch that makes your work look more polished.
- Tells a Better Story: Colors carry meaning. Using shades of green for positive growth or red to draw attention to a problem area helps you tell a more compelling story with your data. Don't underestimate this - it's how you turn a simple chart into a powerful insight.
First, Make Your Chart
You can't change the colors of a chart that doesn't exist yet. If you already have your chart ready, you can skip this step. If not, here’s a quick refresher on how to create one in Google Sheets.
Let's use a simple dataset of website traffic by source for the last month:
Example Data:
To create your chart:
- Enter your data into two columns in your Google Sheet.
- Click and drag to highlight all the cells containing your data, including the headers.
- Navigate to the top menu and click on Insert > Chart.
Google Sheets will automatically generate a chart - often a pie chart or a bar chart - and the Chart editor sidebar will appear on the right side of your screen. Now you’re ready to customize.
How to Change Graph Colors in Google Sheets (Step-by-Step)
The Chart editor is your control panel for all customizations. If you ever close it by mistake, just double-click anywhere on your chart to bring it back. The color options are located under the Customize tab in this editor.
Changing the Color of an Entire Data Series
This is the most common change you'll make. It involves changing the color for all the bars in a bar chart, the entire line in a line chart, or all the slices in a pie chart (we'll cover pie charts in a moment).
For a bar or column chart:
- With the Chart editor open, click on the Customize tab.
- Click on the Series section to expand it. This is where you control the appearance of your data representation (the bars, lines, etc.).
- If you have multiple data series (e.g., comparing traffic from this month vs. last month), you'll see a dropdown menu. Make sure the series you want to edit is selected. For our simple example, it will default to the only one we have ("Sessions").
- Under the format options, you'll see a field labeled Color. Click the color swatch next to it.
- A color palette will pop up. You can select one of the default colors or add a custom color (more on that later).
- Select a new color, and you will see your chart update in real-time.
And that's it! You've successfully changed the color of your data series.
Changing the Color of a Single Bar or Slice
What if you want to highlight a single data point? For example, let's say "Paid" traffic is your most important channel this month and you want to make its bar stand out. This requires one extra click.
- First, click once on any of the bars in your chart. This will select the entire data series, and you'll see selection dots on all the bars.
- Now, click a second time only on the specific bar you want to change (the "Paid" bar). You'll notice that the selection now collapses to just that single bar.
- Look over at the Chart editor. The Series section has now changed to focus on that individual Data point.
- Click the Color swatch that appears.
- Choose a new, distinct color.
This trick is incredibly useful for drawing attention to a high point, a low point, or a specific category you're discussing in a report. This same technique works for other chart types, like changing the color of a single point on a line graph.
Customizing Colors in a Pie Chart
Pie charts operate a little differently because each slice represents a different category and is already a different color by default. So when you edit pie chart colors, you are generally editing one slice at a time.
- Create a pie chart using the method described earlier.
- In the Chart editor > Customize tab, click on the Pie chart or Pie slice sections.
- To change a specific slice's color, simply click on that slice directly in the chart. For example, click the "Organic" slice.
- The Chart editor will update to focus on that "Pie slice."
- Use the Color option to choose a new color for that slice.
- Repeat the process for any other slices you want to customize. This gives you full control over your pie chart's final look.
Changing Other Chart Element Colors
Your data isn’t the only thing you can recolor. You can also change the background, text, and axes for a fully custom design.
To change the chart background color:
- Go to the Customize tab in the Chart editor.
- Click on the Chart style section.
- You'll see an option for Background color and Chart border color. Changing these can help the chart blend in better with your report or presentation. Using "None" for the background color makes it transparent, which looks clean when pasted into Google Slides or Docs.
To change the gridlines and text colors:
- Navigate to the Gridlines and ticks section in the Customize tab. Here you can edit the color of your major and minor gridlines to be more subtle or more prominent.
- Change the color of your chart title and axis labels by going to the Chart & axis titles section.
Pro Tips for Choosing Smarter Chart Colors
Knowing how to change colors is one thing, knowing which colors to choose is another.
Use Your Brand’s Exact Colors with HEX Codes
If your organization has an official brand guide, you can use your exact brand colors by using their HEX codes. A HEX code is a six-character code used to represent a specific color digitally (e.g., #4285F4 is Google's blue).
- When you click a color swatch in the Chart editor, look below the default palette for a "+" button labeled "Add custom color."
- A new window will appear with a color picker and an input field for a Hex code.
- Simply type or paste your brand's hex code into the box (including the # symbol) and click "OK."
- That color is now ready to use and will be stored in your Sheet's custom color palette for future use.
Design for Accessibility and Contrast
Make sure your colors are easy for everyone to see. Avoid pairing light colors with each other, like yellow and light green, as they can be difficult to distinguish, especially for people with color vision deficiencies. Aim for high contrast between your data colors and your background. A tool like Adobe Color has a built-in accessibility checker that can help you select a palette that works for everyone.
Use a "Template Chart" to Save Time
Google Sheets doesn’t have a function to save a custom chart theme, which can be frustrating if you regularly make the same reports. The best workaround is to create a "template chart."
- Create one chart and customize it perfectly - brand colors, font sizes, background, everything.
- Now, whenever you need to create a new chart with the same style, simply click on your template chart, press Ctrl+C (or Cmd+C on Mac) to copy it, and then paste it elsewhere in your sheet.
- With the new chart selected, go to the Setup tab in the Chart editor.
- Change the Data range to refer to your new data.
All your meticulous color and style formatting will be preserved, saving you from having to repeat the customization process every single time.
Final Thoughts
Adjusting the colors of your Google Sheets charts is a simple process once you're familiar with the Chart editor's Customize tab. From branding your reports with specific HEX codes to highlighting key data points with a single click, taking a minute to customize colors makes your data more impactful and easier to understand.
While tweaking a chart in Google Sheets is great for one-off reports, it can become a time-sink across dozens of campaigns and platforms. At Graphed, we've automated this entire process. You can connect all your tools - like Google Analytics, Facebook Ads, or Shopify - and use plain English to build real-time dashboards automatically. Instead of manually formatting charts, you can just ask something like, "Show me a line chart of Shopify revenue vs. Facebook Ads spend for last quarter," and Graphed instantly builds a live, interactive visualization, giving you back hours to focus on strategy, not spreadsheets.
Related Articles
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.
How to Create a Photo Album in Meta Business Suite
How to create a photo album in Meta Business Suite — step-by-step guide to organizing Facebook and Instagram photos into albums for your business page.