I want to create a way to show the goals and the actual over time. So the goal will be a straight line from 0 to the goal in the future and the actual will show where the progress is at the time.
x axis- month
y axis- # of results for each month
It's possible to chart more than one data series on the same chart. One can be your Goal and the other, the actual.
There is a good guide to start learning more about how to manage Charts in FileMaker for you to read
Retrieving data ...