3 Replies Latest reply: Jun 2, 2017 10:38 AM by Sydney Diamond

How to change the color within segments of pie chart

Sydney Diamond Jun 1, 2017 6:00 PM

Hello,

I have pie charts on two different sheets with fields pass, fail, defect. I would like the colors to match up for both. Right now, they are different. I would like pass to be blue, fail to be red and defect to be yellow. Any way to customize the colors within the field/legend so they match?

Thanks!

Re: How to change the color within segments of pie chart

Ivan Bozov Jun 2, 2017 5:34 AM (in response to Sydney Diamond)

Hello! You can use the option color by expression.

Let's say your dimension is called status. Then the expression would be:

if(status='pass', blue(), if(status='fail', red(), if(status='defect', yellow())))

Use this for both pie charts.
Like Show 2 Likes (2)

Actions
- Re: How to change the color within segments of pie chart
  
  Sydney Diamond Jun 2, 2017 10:38 AM (in response to Ivan Bozov)
  
  Very helpful! Thanks, Ivan!
  
  Like Show 1 Like (1)
  
  Actions
Re: How to change the color within segments of pie chart

Vic Obi Jun 2, 2017 5:39 AM (in response to Sydney Diamond)

Hi, Following on from what Ivan said, you can use the IF statement and you can also use the Pick function to do a calculation for the colours
Like Show 1 Like (1)

Actions

Go to original post