Elviswind wrote:The only way I'm aware of to create an algebraic graph in a spreadsheet is to create a column of interesting X values and then calculate the Y values in another column for each X value according to the algebraic formula. Obviously, for higher order polynomials, this won't generate a continuous function, but it should serve most purposes.
Which is what I think crunchy wanted to do.
As for the result not being continuous, that applies to all other solutions too. Either you or the program decide how big steps to take.
Hmm, I just decided to test Gnumeric for creating a graph of sinc(x). I have never really used Gnumeric so the formatting of the plot is maybe not due to limitations in Gnumeric:

I created the x-column by typing the first two values by hand (I did not trust Gnumeric to sort out sin(0)/0 and the third is simply the second + step (= 0.1 in this case) and the rest are just copy-and-paste of the third row.
It is not the best looking plot I have seen but it only took a few minutes to create.
/Martin
Last edited by MartinRF (2011-03-05 09:44:30)