Good afternoon, I'm basically a novice at working with charts thus far and am trying to figure out how to separate a chart into multiple charts at the page level using one query if possible. I was able to achieve this using a crosstab, but wanted to see if it was possible using a chart as well. When I convert the crosstab to a chart, it doesn't return the chart in an easy to read format.
I've got a series of ten unique values (1-10) that I have counting a number of transactions between time periods for staff members. However, as I currently have it configured, it separates on the ten unique values horizontally into a rather large chart with the ten unique values across the bottom of the chart.
What I'd like to accomplish is have it produce one chart for each unique number out of the query vertically, each unique number having its own separate chart.
Is there a way to accomplish this?
Thanks in advance for any help you can provide,
sjdig
I solved my own problem using Master Detail Relationships. :D