Line Chart with Multiple Lines

[jmci]

I've been struggling with something and I don't even know if it's possible to accomplish it in FileMaker.

A client has acquired data from the Medicare about outpatient surgical procedures that have taken place over the last several years. The data is available in one table that contains many fields but there are three fields of interest:

Year: the year in which the surgical procedure took place

Payment Amount: the amount paid for the procedure

Facility Type: the type of facility at which the facility took place (there are four possibilities)

I've also created a summary field called sPaymentAmount

My client wants me to provide a line graph of this data with the Year field along the horizontal (x) axis and the Payment Amount along the vertical (y) axis. That's easy enough. I've done that before. The wrinkle is that he wants to see a separate line in the same line graph showing summary Payment Amount data for each of the four Facility types.

Can FileMaker do that?

What's the trick? Do I have to have the chart in a particular sub-summary part?

[bcooney]

I believe you can overlay two charts, literally.

[jmci]

OK, let's hold that technique in reserve

You seem to be able to add more than one y-axis field. Could that be the solution?