Excel data and charts

[Guest]

I needed to know the values of Column C using the y hat equation, so I put in
{value of a}+{value of B}*A#(data in the a columns). When I inserted a
scatterplot there was only one value plotted. I do I get Excel to calculate
the function in Column C and graph the data?

 

[Jon Peltier]

Make sure it's an XY chart, not a line chart (you can format it to show
lines if you want).

Chart menu > Source Data > Series tab. Click in Y Values box and select the
data in column C. Click in X Values box and select the data in column A.

- Jon