Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

how to change the colour code in pivot table ?

Copper Contributor

Hello, 

In a pivot table, I want to change the colour code to have a different colour for each of the 4 levels. Currently, the Low and Moderate levels have the same colour (yellow). I want to change the colour of the Low level to grey.

 

Gwendal14_0-1701853423941.png

 

Gwendal14_1-1701853691363.png

 

 

2 Replies

Hi @Gwendal14 

 

- Right-click, on the chart, on the color you want to change > Format Data Series...
- In Format Data Series pane > Click on the bucket
- At the bottom you'll see 'Color' > Select the desired one in the list

 

Sample.png

Hi @Gwendal14 

If by any chance this solved the issue... There's a Mark as solution link (at the bottom of the post) that helps people who Search => Thanks