# Charting a mathematical equation using Excel and defined names

## Sample Equations

I'd like to invite the readers to provide nice sample equations!

Contact me when you have found some nice examples to add here.

A sample file can be downloaded here.

Audit !!!

Check out our RefTreeAnalyserthe ultimate Excel formula auditing tool.

Trainings

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

Third party tools

Speed up your file

FastExcelThe best tool to optimise your Excel model!

What has changed?

PerfectXL Compare, for Spreadsheet ComparisonThis Excel compare tool is fast, reliable, and easy to use. Compare two Excel files now and see for yourself!

I'd like to invite the readers to provide nice sample equations!

Contact me when you have found some nice examples to add here.

A sample file can be downloaded here.

## Comments

Showing last 8 comments of 44 in total (Show All Comments):Comment by: Raj (5-6-2015 15:25:51)

y=evaluate(formula)+0*x

and saving workbook in xlsm format (Macro Enabled Work Book)

Comment by: Shubhangi (23-6-2015 21:11:43)

Comment by: Jan Karel Pieterse (24-6-2015 11:30:06)

Enter sin(x) in cell B1

Enter 0 in b3

Enter 6.28 in B4

Enter 2000 in B5

Comment by: CoolKoon (28-11-2015 22:38:32)

Comment by: Jan Karel Pieterse (30-11-2015 12:14:20)

The download file works just fine in Excel 2016, so I figure something else must be wrong with your attempt to replicate.

Comment by: Alfred (5-8-2016 05:14:47)

1. The scope of each and every named range MUST be the sheet that the chart is on.

2. Each and every formula that references the named range, MUST include the sheet name eg. Sheet1!Formula

3. The suggestion to add +0*Sheet1!x to the EVALUATE function will allow the workbook to open without producing an error message about one or more names not being correct.

4. If the formula to chart starts with a negative the addition of ' at the beginning will prevent Excel from trying to turn the entry into a formula for cell B1 eg. '-2*x^2+1

Comment by: Chuck James (27-7-2019 16:21:00)

xStart=-4

xEnd = 4

xNoOfPoints=99

Formula=(sqrt(cos(x))*cos(500*x)+sqrt(abs(x))-0.4)*(4-x*x)^0.1

Comment by: Peter Atherton (21-7-2020 13:26:00)

=xStart+xRange/(xNumberOfPoints-)*ROW(OFFSET(Chart!$B$1,0,0,xNumberOfPoints,1))-1).

I have also tried to plot two equations without success and think I'll have to use the old sheet method for this. Has anyone already solved this?

A couple of formulas I like are:

Bellcurve: NORM.S.DIST(x,FALSE)

Falling Feet: 269-16*x^2, (0,4.1, 6)

Falling Meters: 83-9.81/2*x^2 (0,5.5,15)

## Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.