Series chart question

[FredSa]

Hi,

Having trouble grasping the charting engine.

I have a table with the follow rows:

SchoolType | Percent | Year | Total Students

MS | 99 | 2010 | 12

MS | 22 | 2010 | 10

HS | 80 | 2011 | 25

HS | 70 | 2011 | 20

I would like a bar chart so that there are two series. The first series would be the MS with data from 2010 & 2011 percent average in two bars and then the HS with data from 2010 & 2011 percent average in two bars

I can only get as far as the attached chart. I am stuck figuring out how to chart only the 2010 data as a total and then chart only the 2011data as a total. Help! ZIP of FileMaker file attached. Thanks!

BarProblem.fp7.zip

[comment]

I have a table with the follow rows:

SchoolType | Percent | Year | Total Students

MS | 99 | 2010 | 12

MS | 22 | 2010 | 10

HS | 80 | 2011 | 25

HS | 70 | 2011 | 20

Why doesn't your file fit your example?

[FredSa]

I apologize, my mistake. Proper version attached here.

barVersion2.fp7.zip

[comment]

How about this way?

barVersion3.zip

[FredSa]

This is fantastic! Many thanks. Am I correct that what you did was look at the data in a relationship style so that you can match a single school record to many records of years?

[comment]

Yes, something like that. The first problem is that the years you want to compare must be explicitly indicated somewhere. The second problem is that there is no way to narrow down a summary expression by a specific year.

[FredSa]

I saw the same problems and couldn't get around them much. Summary reports are my weakness since I haven't had much practice with reports. Do you or anyone else know of resources to help think out these processes for charting? Thanks!