Change Chart Colors in Excel & Google Sheets

Change Chart Colors in Excel

Starting with your Data

We’ll start with the data below showing a bar graph comparing revenue of two items. There are several ways that we can change the colors of a graph.

 

Changing Entire Series Color

1. Click once on your series. (This will highlight all series items as shown below)
2. Select Format
3. Change Shape Fill or Shape Outline

 

Changing Single Data Point Color

1. Click twice on your series item. (This will highlight all series items as shown below)
2. Select Format
3. Change Shape Fill or Shape Outline

 

Changing Theme Color

1. Click on graph
2. Select Chart Design
3. Click Change Colors and select your color theme

 

Change Chart Colors in Google Sheets

Starting with your Data

We’ll start with the same data that we did for the Excel version.

 

Changing Entire Series Color

1. Click on your Series twice
2. Under Chart Editor, select the Fill Color under Series

 

Changing Single Data Point Color

1. Click on your single data point three times
2. Change your Fill Color Under Format Data Point

 

Changing Theme Color

1. Click on Graph
2. Select Format
3. Click Theme

 

 

4. Select your Theme