Excel data and charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top