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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Damo447" wrote in message
...
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