MS Access Graphing two categories side by side from the same query

Dear Experts,

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!
Test.accdb
shogun5Asked:
Who is Participating?
 
als315Connect With a Mentor Commented:
Do not remove type (positive-negative) from your query and show both types on chart. Look at sample (frmChart1)
Test-01.accdb
0
 
shogun5Author Commented:
Wow! Thanks! Yep! That's exactly what I am looking for. Thanks again for the quick response!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.