Just not sure how to do this. Using the attached sample database I have set up a Column chart that pulls from a query of student behaviors both count of positive and count of negative. I can graph the positive 'OR' negative by changing the value in the criteria but users want to see both 'positive' and 'negative' on the same chart with either category represented by a different color. So positive would be one color and negative would be another. I have dates on the x axis. Some days there will be both positive and negative values (two columns) but other days there may just be one column of values.
I am really stuck on how to get both categories on the same chart.
Any assistance would be greatly appreciate!