Download Files:

Start File:
https://excelisfun.net/files/EMT1396-97.xlsx

https://excelisfun.net/files/EMT1397%20Part%2002.xlsx

https://excelisfun.net/files/EMT1397%20Part%2003.xlsx

See how to create formulas and a chart for Category Totals, Running Totals, and % Running Totals:

1. (00:15) Introduction. Why you might use formula rather than a PivotTable.
2. (02:00) Create formulas for Lower and Upper Limits
3. (03:23) Text Formula for Category Label
4. (04:15) COUNTIFS function to get Frequency Count
5. (07:23) FREQUENCY Array Function to get Frequency Count
6. (09:55) SUM function and expandable range for Running Total, Cumulative Frequency
7. (11:10) % Running Total, % Cumulative Frequency Formula
8. (11:55) Ogive Chart using a Line Chart and Error Bars
9. (18:42) 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 1397 Part 3: % Frequency Running Total Formula w Irregular Increments & X-Y Scatter
Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks