Excel Forum

Excel Magic Trick 576: Dynamic Break Even Chart using INDEX and MATCH functions

See how to Add a point and a dynamic label to a Break Even Chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.
Videos that show how to create table:
Excel Magic Trick # 254: Data Table Creates 100 Formulas
The Beauty Of Excel #1: Formulas & Functions
The Beauty Of Excel #2: Formulas, Functions & Charts

Got a Question? Ask it Here in the Forum.