Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Articles > Chart an Equation
Deze pagina in het Nederlands

Charting a mathematical equation using Excel and defined names

When doing mathematics, wouldn't it be nice if we could type an equation into a cell in Excel and immediately see the resulting graph?

This article describes how this can be achieved by using just 4 input cells and a set of defined names.


Turns out this trick has been demonstrated before: Stephen Bullen has created an almost identical version of this workbook a long time ago, probably using Excel 5. Look for a download called