graphing

[Chris]

Is it possible to generate graphs in Excel using just an
equation? For example, If I want to graph the line
y=2x^2+3x+2, can I graph this line without putting in a
series of x and y data points. Thanks in advance.

Chris

 

[Frank Kabel]

Hi
have a look at
http://www.tushar-mehta.com/excel/software/plot_manager/index.html

 

[Jan Karel Pieterse]

Hi Chris,

Is it possible to generate graphs in Excel using just an
equation? For example, If I want to graph the line
y=2x^2+3x+2, can I graph this line without putting in a
series of x and y data points. Thanks in advance.

- create a normal xy scatter chart

Define these names:

xdata
refersto: =row(1:1000)

ydata
refersto:
=2*xdata^2+3*xdata+2

Now select the series of the chart and modify its series formula so it
looks like this:

=SERIES(,Book1.xls!xdata,Book1.xls!ydata,1)

Make sure you change the Book1.xls entries to the name of your file.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com