Chart an Equation

JKP Application Development Services.

Microsoft Office Application Development

Chart an Equation

Up • Defined Names • Corrupt Files • Create Addins • Startup Problems • Chart an Equation • Show Picture • Round2Digits • Control Events • Custom Find • FormulaWrapper • Disable Events • Workbook Open Bug • WebQuery • Register UDFs • Undo With Excel VBA • Select a range (VBA) • Transpose Table • Docking VBE Windows • Excel 2007 Tables • Excel 2007 Tables (VBA) • Update An Addin • Addin Installation • Object Lister • Excel 2007 FileFormat • Catch Paste • Listbox AutoSize • Fix Links to UDFs

• Introduction • Create the Chart • x-values • y-values • Sample Equations •

Search

Zoeken

Go to	Ga Naar
Home Up Introduction Create the Chart x-values y-values Sample Equations

Donate	Donaties
Did you find something helpful on my site? Consider a donation! Heeft u iets gevonden waar u wat aan had? Overweeg dan een donatie!

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.

Content:

Creating The Chart

Getting x Values

Getting y Values

Sample Equations

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 ChtFrmla.zip.

Subscribe in a reader

Use the contact page to issue questions or comments about this website.
Copyright © 2003-2008 JKP Application Development Services