Hello
i have a bar graph on a report. i need to know how to set the color for the different data points without the color changing depending on the output. here's what i mean.
if the result is equal to 1 then the data point for the value 1 should always be white,if the result is 2,3,4 and 5, the data points for these values should always be yellow and 6,7,8,9 should be always be red. it works fine if all of the numbers are in the table, but if i am missing a number, the colors just mix and don't keep their set color. please may you help me with this problem, all the data points should have a permanent color regardless of what the output for the report graph is. thank you