Is there any way to chart multiple series on a line chart based on the current records?

I would like to chart a known set of values, such as months of the year, along the X axis. Then have a series (sales) for each person on the Y axis based on the current found set where each record is a series on the chart. It seems like the Y axis must be defined when creating the chart.

Can FMP11 do this or should I look at plugins?

Thanks,

Scott

I think it would take some modifications or additions to your database structure to use Filemakers built in graphs. In a file maker plot each record represents a value along the X axis. In your case this would be months of the year. To have multiple persons show up as a different series then you would need to create multiple user fields on each record Sales_person1, Sales_person2, etc. If a person has no sales listed then this series will not appear on the graph.

n/m problem solved