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.