Chart customization (title, legend, colors) in Google Sheets - Step-by-Step Guide

Introduction

Customizing charts helps make your data easier to understand. You can change the chart title, adjust the legend, and pick colors that make your chart clear and attractive.

When you want to add a clear title to explain what the chart shows

When the legend is covering important data and needs repositioning

When you want to use specific colors to match your report style

When you need to highlight certain data series with different colors

When you want your chart to look professional and easy to read

Steps

Step 1: Click

- the chart on your Google Sheets

The chart is selected and a blue border appears around it

Step 2: Click

- the three vertical dots menu at the top right corner of the chart

A menu appears with options including 'Edit chart'

Step 3: Select

- 'Edit chart' from the menu

The Chart editor panel opens on the right side of the screen

Step 4: Click

- the 'Customize' tab in the Chart editor panel

Customization options for the chart appear

Step 5: Expand

- the 'Chart & axis titles' section

Fields to edit the chart title and axis titles become visible

Step 6: Type

- the 'Chart title' text box

The chart title updates immediately on the chart

Step 7: Expand

- the 'Legend' section

Options to change legend position and font appear

Step 8: Select

- a new position from the 'Position' dropdown (e.g., 'Right', 'Bottom')

The legend moves to the selected position on the chart

Step 9: Expand

- the 'Series' section

Color options for each data series appear

Step 10: Click

- the color box next to a series name

A color palette opens for that series

Step 11: Select

- a new color from the palette

The selected series color updates on the chart

Before vs After

Before

Chart has a generic title 'Chart 1', legend at the right, and default colors

After

Chart title changed to 'Monthly Sales', legend moved to bottom, and series colors changed to blue and green

Settings Reference

Chart title

📍 Chart editor panel > Customize tab > Chart & axis titles

To add or change the main title of the chart

Default: No title or default title based on data

Legend position

📍 Chart editor panel > Customize tab > Legend

To move the legend to a better place or hide it

Default: Right

Series color

📍 Chart editor panel > Customize tab > Series

To change the color of each data series for clarity or style

Default: Automatic colors assigned by Google Sheets

Common Mistakes

Typing the chart title in the spreadsheet cells instead of the Chart editor

The chart title will not update automatically and may not appear on the chart

Use the Chart editor panel under Customize > Chart & axis titles to set the chart title

Hiding the legend by setting position to 'None' without adding labels on the chart

Viewers may not understand which color represents which data series

Only hide the legend if the chart is simple or labels are clear on the chart itself

Choosing colors that are too similar or hard to see

It makes the chart confusing and hard to read

Pick distinct, contrasting colors for each series to improve clarity

Summary

You can customize chart titles, legend positions, and colors to make charts clearer and more attractive.

Use the Chart editor panel's Customize tab to find all these options.

Always choose clear titles, visible legends, and distinct colors for the best chart understanding.