• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About

Google Sheets: Change Graph Colors

November 11, 2019 by Mel Hawthorne 2 Comments

Google Sheets is a fantastic tool for keeping track of data, and for visualizing it as well. Graphs, Charts and more – thanks to Google’s free online program, it’s easier than ever. Or, at least, it should be. Not every function is always apparent, especially for new users, so here are some tips on how to change the colors of your graphs and charts, and a few other tips that will help you make the most of your spreadsheets.

  1. Right-click on your chart and select Chart Style
Right-click menu

Simply right-click on the chart you want to restyle and select the Chart Style option. A tab labelled Chart editor will open on the right-hand side of your worksheet, and you’ll be able to make some changes to your chart.

  1. Locate the options you want to change
Chart style options

You can restyle a fair few things – in the Chart style section, you can change the background and border colours of your chart. The other sections will depend on what type of chart you are using. From pie to line charts to sparklines and other graph types, Google Sheets offers several options.

For a pie chart, you can change both the border of the pie and the colours of the slices. Simply click on the drop-down option to select the segment you want and use the colour picker to adjust it to what you need. In the title and legends options, you can edit text colours as well as font options.

  1. Close the Chart editor

Once you’ve set all the options, you can close the editor – your changes save automatically. You can then continue working with your sheet!

Tips:

  • Make sure you have the best chart for your purposes – Google sheets supports a lot of different chart types, including line, area, column, pie, bar, geo and map charts as well as a few others – don’t settle for a bar chart if a map would work better for you!
Different graphs
  • Make full use of the options you have – don’t hesitate to play with the settings until you find what works for you. From picking more easily legible fonts to dragging and dropping the legend of a graph to somewhere more useful, experiment until everything is just right.
  • Lock your graph when you are done – Use the Protect Cells & Ranges feature to make sure you don’t accidentally change something around on your graph!

 

You Might Also Like

  • Windows Command Prompt: How to Change the Font and Colors
    Windows Command Prompt: How to Change the Font and Colors
  • Google Sheets: How to Use the Google Translate Formula
    Google Sheets: How to Use the Google Translate Formula
  • How to Convert Google Sheets to PDF
    How to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other Row
    Google Sheets: How to Shade Every Other Row
  • Troubleshooting Google Sheets Goes Blank
    Troubleshooting Google Sheets Goes Blank
  • Google Sheets Won't Let Me Type - Fix Guide
    Google Sheets Won't Let Me Type - Fix Guide

Filed Under: Internet

Reader Interactions

Comments

  1. JME says

    November 23, 2021 at 8:52 pm

    The information missing in the article is to click the bar or line you want to change the color of, it will then pull up a menu you can edit.

  2. Jan Olson says

    September 24, 2021 at 9:05 am

    Nope, this only addresses the background and font, not how to change the legend indicator color

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

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

Primary Sidebar

Recent Posts

  • How to Find Your Lost Samsung Phone
  • How to Change Microsoft 365 Two-Factor Authentication
  • How to Export Chrome Bookmarks
  • How to Make Your iPad’s Keyboard Bigger
  • How to Enable and Manage Do Not Disturb on iPad (iPadOS 16.5)
  • How to Put Apps to Sleep in Windows 11
  • Fix: Excel Opens in Tiny Window
  • What is SMPS?

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

You May Also Like

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy