how to create curve of accumulated data A divided by acc data B ?

[#1]

Hello,

I try to realize a graph with 3 curves:
- Accumulated curve (data A)
- Accumulated curve (data B)
- Curve representing the division of the accumulation of the data A by the accumulation of the data B

I manage well to make 2 first ones (with option "total accumulation" checked in the properties of the graph) but not the 3rd...

I think it exists a formula for that, but my tests are not really decisive for the moment...

Thank you in advance for any help on this subject!

Vincent

[hic · Accepted solution]

Skip the option "Accumulation" and do it in the formula instead.

First, add expressions for the accumulated A and B:
RangeSum(A, above(A_accumulated))
RangeSum(B, above(B_accumulated))
Label these expressions "A_accumulated" and "B_accumulated".

I assume there is only one value per bin. If there are several values per bin, you need to use Sum(A) instead of A as first parameter in RangeSum.

Finally, add an expression A_accumlated/B_accumlated.

[swuehl]

Try to calculate the accumulated curves (instead of the chart properties option) like

=rangesum(above([data A],0, rowno() ))

=rangesum(above([data B],0, rowno() ))

[for the first parameter to above, use your current expressions]

Then you could just use

=column(1) / column(2)

as division of both accumulated values.

Hope this helps,

Stefan

[#4]

thanks for your answers, both are ok !