How to plot multiple series on one line graph?

[#1]

Attached is a sample data file.  Along the bottom would be an axis from 0 to MAX.  At any point on the x-axis, it would plot three series using full accumulation: 1. The count of P1's that have the x-value or less.  2. The count of P2's that have the x-value or less.  3. The count of P3's that have the x-value of less.  How can I accomplish this?  Thank you.

[swuehl · Accepted solution]

Maybe like attached?

I created a variable vMax to get the Max value of P1, P2, P3 like

=ceil(RangeMax(max(P1),max(P2),max(P3)))

Then I created a line chart with an artificial dimension

=valueloop(0,vMax,1)

and then 3 expressions:

=count(if(P1 <=ValueLoop(0,vMax,1),Key))

=count(if(P2 <=ValueLoop(0,vMax,1),Key))

=count(if(P3 <=ValueLoop(0,vMax,1),Key))

Hope this helps,

Stefan