Excel data and charts
 

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?

Excel data and charts
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"gjohnson15" wrote in message
...
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?