Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Increments

Download Files:

Start File:

See how to create a formula for % Running Total when the Increments are Irregular. Also see how to create an X-Y Scatter “Ogive” or % Cumulative Frequency Chart:

1. (00:14) Introduction.
2. (01:29) COUNTIFS & COUNT formula for % Cumulative Frequency or % Running Total for Counting
3. (04:36) X Y Scatter Chart for Ogive Chart or % Cumulative Frequency Chart
4. (11:54) Summary

Reference Videos:
Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples)
Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart
Excel Magic Trick 1397 Part 2: Formulas: Monthly Revenue, Running Total & % Running Total & Chart
Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks

[shoeshines]

With every video on this channel, I continue to learn and have fun doing it. The "Select Data" feature on the charting ribbon tab really unlocks the power of the chart. Cool trick to use 0 as the X-label Y values to generate the error bars.

[hermannzon]

Really happy to have liked your pages. I have a lot of fun while Learning!

[ikark]

ExceLent tutorial about making really elegant diagrams! Thanks!

[muhammadfathi]

Great video as always, thank you so much Mike,

[Berghiker]

I am just looking for the cumalitive % gain or loss on a total amount. How do I do this?