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

shogun5
shogun5 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Do not remove type (positive-negative) from your query and show both types on chart. Look at sample (frmChart1)
Test-01.accdb

Author

Commented:
Wow! Thanks! Yep! That's exactly what I am looking for. Thanks again for the quick response!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial