graphing

C

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
 
J

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.
Click to expand...

- 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
 
Top