Background Color in a pie chart

[mparker123]

Hello All,

I am building a pie chart and having and issue with the background color under the expressions tab. I have values called Issue Types and I created a set analysis to take out the values that I don't want. However, when I put the background color in, the pie chart shows the values that the set analysis took out. I am using the following formula in the "Background Color" expression:

=If(issue_type='PLandG',RGB(252,115,98),If(issue_type='GConfig',RGB(141,170,203),If(issue_type='MDB Config',RGB(187,216,84),If(issue_type='OnBC',RGB(255,217,47),If(issue_type='Con',RGB(102,194,150),if(issue_type='GLR',RGB(229,182,148),If(issue_type='P',RGB(231,138,210),If(issue_type='FC',RGB(179,179,179),If(issue_type='CA&R',RGB(166,216,2227),If(issue_type='TSC',RGB(171,233,188),If(issue_type='TDMSBandS',RGB(27,125,156),If(issue_type='OMSC',RGB(255,191,201),If(issue_type='P:P',RGB(77,167,65),If(issue_type='CA',RGB(196,178,214),If(issue_type='CR',RGB(178,36,36),If(issue_type='D',RGB(0,172,172),If(issue_type='CB',RGB(190,108,44))))))))))))))))))

Is their something missing from the formula that would be causing the chart to show the values that I excluded?

[vishsaggi]

Just a small suggestion. Rather than using that long multiple if statements you can try using Pick(Match()) like

= Pick(Match([Issue Type], 'C B', 'CA','CA&R','Con','CR','D','FC','GC','GLR','MDB Config','OBC','OMSC','P','P: P','PL and G','TDMSDandS','TSC'),

             RGB(190,108,44),RGB(196,178,214),RGB(166,216,227),RGB(102,194,150),RGB(178,36,36),RGB(0,172,172),RGB(179,179,179),RGB(141,170,203),

             RGB(229,182,148),RGB(187,216,84),RGB(255,217,47), RGB(255,191,201),RGB(231,138,210),RGB(77,167,65),RGB(252,115,98),RGB(27,125,156),

             RGB(171,233,188)

      )  

Just replace your if's with Pick(Match())