Title

Creating a Line Graph

Post

Forum,

I'm trying to create a line graph in FileMaker pro 13 Advance and the problem i'm having is the chart or graph is giving me duplicate numbers and the numbers are in a vertical order. This database is setup to run a Fiscal Year report. But in setting this up I ran into this problem with the line graph. The table information is setup as such and the table is called: LRC Enrollment

I know it's a lot! The answer to your first question is the LRC Enrollment table. Second, I'm trying to chart the FY 2013, FY 2014 and FY 2015. Third, I need the X-Axis to represent the FY 2013, FY 2014 and FY 2015 and have the Y-Axis display the Title FY 2013 FY 2014 FY 2015. I would only need just one (1) line on the chart.

It's funny because I can use the other chart options; pie chart, columns, area and even the line chart when changing the data source to Current Found Set (Individual record data) and it works, but it doesn't work! For the line chart it give me more lines then I need and it gives me duplicate numbers and not just one number for each Fiscal Year.