I am not sure if I understand what you are trying to do based on the information you provided... Hopefully this helps.
If you place the X-axis in the Xaxis, and the yaxis in the location, you should notice towards the bottom of the dialog, the Use Data From : "current found set" and a checkbox that states "show data points for..."
Try checking the checkbox and then looking at the chart in browse mode.
Hmm didn't work. The database is very small, is there a way I could get you to look at it and tell me if it is possible to create the chart I want?
I'm not exactly sure what you're looking for, even if I was to look at it.
Can you tell me what fields you have and what you're trying to chart?
If your database is very small, perhaps there aren't enough records in the found set to "trigger" the smallest unit displayed by the graph. Although I use FMPA 10, I've found a way to use bar graphs and have encountered this situation before.
Yep here are the fields:
Name - text
Date - calendar drop down
Time - auto filled
Lesson - choice drop down list
The database was designed to help me look for patterns in children's behaviour which results in them being sent out of class. I'm trying to graph the lesson field to see a particular lesson has more children being sent out than others.
When the chart is plotted all I get are the axis with the choices from the lesson drop down and a vertical numbered axis (this is what I want) but all the bars are zero even though there are 10 records filled in which should show maths being the predominant bar.
Any ideas why Filemaker is not plotting the data?
Many thanks all sorted, however I needed to use the sort function on the lesson field to get the graph to display properly.