Microsoft Excel Graphing Question?

Question

Quick ? That should be easier than anything, but I can't figure out.

If you have a list of Y-Intercepts and a List of Slopes

Can you graph a line or points with Y=MX+B of something of the sorts

The point of it being, if you have a certain return ratio (call it A) you get a certain % back (B).


Hopefully Someone can shed some light on this!

Answer 1

I always just enter my data, then click on chart wizard to create the graph. You would need to set up your calculations within the data