creating graph in excel?

[ashish]

hello ,

can anyone  help me , i don't know how to create graph of an equation in excel !

i have the equation
Y^2 = 2.5x-(0.5*9.81*x^2)

[Nobody]

Put your x values in column A and your y values in column B

Select columns A and B and invoke the ChartWizard. The chart type you want is XY (Scatter).

If you don't have any values but a function like f(x) = cos(2^x), you have to decide what x range you want to graph and how fine the graph will be, i.e. what is the interval between data points, small interval=smooth graph.

Put the lowest x value in A1, put the interval in D1
in B1 put your formula =COS(2^A1) and drag it down to B2
in A2 put the formula =A1+$D$1.
Then select A2:B2 and drag down until you have enough data for your needs.

THEN invoke the Chart Wizard.

[Nobody]

tell me if it doesn't work!

[ashish]

tell me if it doesn't work!

i didn't get it

here is the formula : Y=(10x)-(0.5*9.81*X²)^0.5
domain will be between (1-10)

what data should i insert and where?

[Nobody]

on column A, put the values of the domain
that's is in your case, 1 to 10

now, in column B put the formula
in your case, the formula will be

=(10*A1)-(0.5*9.81*A1^2)^0.5

amusing, you put this formula in the cell B1 and having the first domain in the cell A1

after that, repeat the same thing for other 9 rows. Until you reach the last number of your domain.
and, then select the whole thing and create a chart!

check the images that i'd uploaded.

[ashish]

thank you very much +rep

[Nobody]

Anytime