I couldn't decide if this belonged here or under scripting, but decided to go with this since others may want the same info.

I think this is fairly easy, but I can't quite get it.

I want to chart a calculation so here's an example:

X - Date Field

Y - Dollar Amount Field, but only where Owner Field is =1

This way I can have a separate Y line for each "owner".

Hi "Gar",

Sure -- you can have up to 12 separate lines on a line chart. You just have to add them one at a time as a separate series, by clicking the "+" sign beneath the "Vertical (Y) Axis" area in the Chart Setup dialog box.

Cheers,

-Lee

Hi Garden Level,

What version of FileMaker are you using?

If you have upgraded to 11, please update your profile. This link will explain how to do this. Update Profile

Lee

AFAIK

You will also need a separate relationship for each line on the graph

Something like

date_INV_Owner1::totBalance

date_INV_Owner2::totBalance

hope this helps