How many types do you have?
You need adding Y-series for every type (line on chart), so corresponding data looks like
type1 type2 type3...
Define calculation fields in this table such as:
If ( category = D ; amount )
For each category.
Refer to the calculation fields as your Y-Series
Or use the "Delimited Data" option and use ExecuteSQL to produce each of your X and Y - Series. This avoids the need to create calculation fields, but requires using SQL...
I made a sample with a DashBoard layout.
It's another way to do this and does not require SQL ( this way you need to create extra fields and relationships).
2017 line chart.fmp12.zip 69.8 K