Plot/calculate values of equation

**Carlsbergen** · 08-23-2013, 06:53 AM

Hi.

I was wondering if it is possible for Excel 2007 to calculate values for an equation without resorting to the usual way
of creating a list of step values and inserting the formula in each cell.
Example:
equ_2.jpg

What I would like to do is to have a cell where I can type the number of steps and the size of step increments
I want to calculate and then plot the resulting curve in a chart.
The way I described above is fine for smaller lists, but I want to calculate 30000-40000 steps sometimes.

Thanks in advance for any help.

Best regards

**oeldere** · 08-23-2013, 07:28 AM

You get better and quicker result on your question if you follow the advice in the link below.

http://www.excelforum.com/the-water-...-question.html

**Carlsbergen** · 08-23-2013, 07:32 AM

Originally Posted by oeldere

You get better and quicker result on your question if you follow the advice in the link below.

http://www.excelforum.com/the-water-...-question.html

Cool.

Here is a sample workbook:
plot_equation.xlsm

**oeldere** · 08-23-2013, 08:46 AM

Yes, thanks for that.

But I don't understand the question.

What has to be done / changed.

**Carlsbergen** · 08-23-2013, 09:34 AM

Originally Posted by oeldere

Yes, thanks for that.

But I don't understand the question.

What has to be done / changed.

Is there a way to plot the same chart without having to make the table of values in the D and E columns?
If I wanted a much lager range of x, say 1-40000, then the list would be very long.
My goal is to avoid such long lists in my sheet.