New: ready-to-use spreadsheet templatesExplore the collection  →
Google Sheets · Verified tutorial

Change chart colors in Google Sheets

Create a column chart from A1:B5. In Customize > Series, set the Revenue series color to #4f46e5. Do not change any values.

Verified by PhilisAbout 60 seconds
Quick answer

Create a column chart from A1:B5. In Customize > Series, set the Revenue series color to #4f46e5. Do not change any values.

Step-by-step

1

Select the targetCreate a column chart from A1:B5.

2

Apply the changeIn Customize > Series, set the Revenue series color to #4f46e5.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

A column chart uses A1:B5 and its Revenue series is colored #4f46e5.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select A1:B5 and repeat the final action. A column chart uses A1:B5 and its Revenue series is colored #4f46e5.

Example spreadsheet data

This is the clean fixture used for the verified run.

MonthRevenue
Jan120
Feb180
Mar150
Apr220

Video transcript

  1. Open the prepared Practice spreadsheet.
  2. Select the target. Create a column chart from A1:B5.
  3. Apply the change. In Customize > Series, set the Revenue series color to #4f46e5.
  4. A column chart uses A1:B5 and its Revenue series is colored #4f46e5.