Is it possible to use an event code to change the color of a line graph. For example if I have a data series with the totals and another column with a color code i.e.#FFFFFF could I make that collum always that color.
i.e SQL as follows
As you can see in the above data sql i have grouped it by month and question number. Now I want question 1's to be a set color
Is their a way?
Regards
Richard