• Skip to main content
  • Skip to primary sidebar

Technipages

Smart phone, gadget and computer tutorials

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About

Google Sheets: Change Graph Colors

Posted on November 11, 2019 by Mel Hawthorne Leave a Comment

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 ColorsWindows Command Prompt: How to Change the Font and Colors
  • Google Sheets: How to Shade Every Other RowGoogle Sheets: How to Shade Every Other Row
  • How to Convert Google Sheets to PDFHow to Convert Google Sheets to PDF
  • Troubleshooting Google Sheets Not PrintingTroubleshooting Google Sheets Not Printing
  • Setting Up Macros in Google SheetsSetting Up Macros in Google Sheets
  • How to Spell Check in Google SheetsHow to Spell Check in Google Sheets
  • How to Export All Google Sheets to Your ComputerHow to Export All Google Sheets to Your Computer
  • Google Sheets Won't Let Me Type - Fix GuideGoogle Sheets Won't Let Me Type - Fix Guide
  • Google Sheets vs Excel ComparisonGoogle Sheets vs Excel Comparison

Filed Under: Internet Tagged With: Google Sheets

Reader Interactions

Did this help? Let us know! Cancel reply

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

  • Microsoft Teams: Mouse Scroll Wheel Not Working
  • Fix Microsoft Teams Browser Not Supported
  • Android 10: How to Adjust the Keyboard Size
  • OneNote Error Code 0xE00001AE – Fix
  • WhatsApp: How to Change Your Phone Number
  • Fix OneNote Error 0xe00001bb: Section Is Corrupted
  • Zoom: How to Show the Unread Message Icon
  • How To Calculate Tips on Android

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.

Follow me on Twitter, or visit my personal blog.

You May Also Like

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2021 Technipages · All Rights Reserved · Privacy