View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default How can I graph an equation instead of points?

Scott,

Make up two columns, one with your xvalues (let's say, from A2 down), the other with the formula

=m*A2+b

where A2 is the first of your xvalues. Substitute m and b with values or cell references - like $C$2

Then copy that formula down, and graph based on that table.

HTH,
Bernie
MS Excel MVP


"Scott Murphy" <Scott wrote in message
...
Instead of plotting points on a graph, I would like to graph an equation in
the form of y = mx + b. How should I put this into a chart?