Hi Brian,

Unfortunately, Excel 2003 worked just fine, but later versions seem not to like this technique very much.

I lack time to try and figure out what is wrong though, sorry!!

Comment by: Raj (6/4/2015 7:30:39 AM)

deeplink to this comment

Sir the following equation used in google graph also worked which include cos etc functions with following dataset

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: Raj (6/5/2015 3:25:51 PM)

deeplink to this comment

tested on excel 2007 & worked with taking
y=evaluate(formula)+0*x
and saving workbook in xlsm format (Macro Enabled Work Book)

Comment by: Shubhangi (6/23/2015 9:11:43 PM)

deeplink to this comment

Sir can you please tell how can I perform slicing of a sine wave at 1000 time instants using Charting a mathematical equation using excel?

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

deeplink to this comment

Hi Shubhangi,

Enter sin(x) in cell B1
Enter 0 in b3
Enter 6.28 in B4
Enter 2000 in B5

Comment by: CoolKoon (11/28/2015 10:38:32 PM)

deeplink to this comment

I've tried to do this in Excel 2013, but to no avail: the offset function gave me an error for the formulation outlined in the article and it seems that Microsoft has removed the "evaluate" function completely (it doesn't show up even in the complete function list or anywhere else). I don't suppose you have a workaround for Excel 2013, do you?

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

deeplink to this comment

Hi CoolKoon,

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 (8/5/2016 5:14:47 AM)

deeplink to this comment

I just set this up using Excel 2010. It works if the following rules are followed.
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

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.

Subscribe to our mailing list

Charting a mathematical equation using Excel and defined names

Sample Equations

Comments

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