Can I create a line graph based on a formula

[Damo447]

I have been doing some regression analysis manually and have worked out a
y=mx+a formula. Is it possible to create a graph based on the fomula rather
than creating a graph cost figures?

My answer is y=4.5x+16.714

 

[Bernard Liengme]

Put some text in A1 and B1 (example : X and Y )
Put some x-values in A2:A20 or more
In B2 use =4.5*A2+16.714
Copy down to B20 (or more)
Select A1:B20 and use Chart Wizard to make XY chart
best wishes

 

[Jon Peltier]

The answer is, yes you can, but in general it's far easier (and easier to
understand and debug) to use the approach which Bernard has suggested.

- Jon