pie Chart Colors

[Medea]

Hello,

I have a chart that is, for the most part, working. Just one issue. I want to colors to remain constant. Ex: Yes = Red, No = Blue, N/A = Yellow. If there are no "YES" answers, "No" and "N/A" should remain blue and yellow. Is very anyway to assign chart points based on value? I have looked everywhere and nothing I have tried is working. ANY help would be greatly appreciated.

The data is counting how any of each answer (Yes, No, N/A) is associated with each question. Ex: Question 1 = 5 No, 3 N/A and 12 Yes. Hope this make sense.

Thanks,

Trish

 

[liddlem]

Hi Medea
I think that the way to get around this is to use a the Nz(Count) function in your query (check the properties of the chart) like this.

TRANSFORM Nz(Count(AnswerField))+0 AS CountOfAnswers
SELECT IncType
FROM [TableName]
GROUP BY IncType
PIVOT AggType IN ("Yes", "No", "N/A");

 

[Medea]

Thanks so much! I will try that and let you know how it works!

Trish