Line Chart with 2 Different Size Series

[emarchewka]

I have two tables, each has a column called Comp_ID. When filtering by Comp_ID, table 1 has 127 records and Table 2 has 4 records.

Here are snippets of each table:

Table 1

Table 2

I want to plot these on a single chart with Loss on the x-axis and Probability (Acceptable_P and Prob_Inherent) on the y-axis.

I created a view with an inner join on Comp_ID. When I build my datapage I get 4 instances of the curve for the table with the 127 records and a step chart for the 4 record table.

However, if I chart these individually I get the nice curves as expected.

I can do this in Excel easily but struggling with building this chart in Caspio, TIA.

This is the screenshot from Excel - 

Edited June 17, 2020 by emarchewka
Clarification with images

[emarchewka]

While searching for some solutions I came up a solution that works.

One table with the LEC_Type as a single series. That allowed for different lines and worked.