Forum Discussion

Gwendal14's avatar
Gwendal14
Copper Contributor
Dec 06, 2023

how to change the colour code in pivot table ?

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.

 

 

 

 

excel

2 Replies

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Dec 11, 2023

    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

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Dec 06, 2023

    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

     

Resources