Hi there,
I have a table that contains values of a questionnaire.


For instance,

question 1 = 1 (represents strongly agree)
question 2 = 4 (strongly disagree)

I am producing pie charts to represent this data so that it is clear to see the majority of the answers for each question.

The problem I am having is that if a value doesn't exist within a question (eg 3 (disagree)) then the color of the next value (more than likely 4) will become the color that '3' was supposed to be, therefore invalidating my generic legend key, as I have multiple charts on one form.

Is there a way round this?
Such as colouring the piece in a certain color depending on its value, such as...
if (value = 3){color = yellow}
else if (vlaue = 4){colour = red}

Thanks