• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 65
  • Last Modified:

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!
1 Solution
Do not remove type (positive-negative) from your query and show both types on chart. Look at sample (frmChart1)
shogun5Author Commented:
Wow! Thanks! Yep! That's exactly what I am looking for. Thanks again for the quick response!
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.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now